It’s an old posting, but I came across this item a few days ago where Tom Kyte has listed URLs to several of the useful utilities that he has published on the Internet.
(I’m hoping the print_table() routine will appear on the list some time soon. It’s disappeared from the link I used to have for it.)
i the meantime, you might use [link no longer works, so deleted - jpl]
Comment by Sokrates — February 27, 2010 @ 7:18 pm UTC Feb 27,2010 |
Sokrates,
Thanks for the URL you supplied, unfortunately it no longer points to the code, and the link on the page it gets to is also a dead end, so I’ve deleted the URL.
Mark,
Thanks for that temporary measure. I think Tom had an improved version of that code that dealt with more of the special cases, but that one looks as if it will be good enough for most people most of the time.
Comment by Jonathan Lewis — February 28, 2010 @ 12:03 pm UTC Feb 28,2010 |
I can’t find a cached copy of Tom’s code, but I did find this.
java2s.com, Print table with dynamic query: http://bit.ly/b0xW7p
Comment by Mark — February 27, 2010 @ 11:55 pm UTC Feb 27,2010 |
http://web.archive.org/web/20080220222310rn_1/asktom.oracle.com/tkyte/print_table/
says:
“…
in sqlplus — how can you do that? well — click here: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1035431863958 and grab the code for print_table…
…”
since asktom is ported to apex now, this URL does not work anymore, it has to be replaced by
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1035431863958
Comment by Sokrates — February 28, 2010 @ 2:30 pm UTC Feb 28,2010 |
Sokrates,
Thanks for coming back with the updated URL.
Comment by Jonathan Lewis — February 28, 2010 @ 2:44 pm UTC Feb 28,2010 |
Hi Jonathen,
In free space report scripts (http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551402703363001567), getting 100% usage for the last column (“pct_max_used” in script) when tablespace got only used 50%
*a SYSAUX 512,000 258,752 253,248 50.5 251,392 512,000 100.0
Is it should be decode( kbytes_max, 0, 0, ((kbytes_alloc-nvl(kbytes_free,0))/kbytes_max)*100) ?
Regards,
Vineeth
Comment by Vineeth Kalanthodi — March 8, 2010 @ 4:59 pm UTC Mar 8,2010 |