Oracle Scratchpad

February 27, 2010

Tom Kyte

Filed under: Oracle — Jonathan Lewis @ 7:03 pm BST Feb 27,2010

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.)


  1. i the meantime, you might use [link no longer works, so deleted – jpl]

    Comment by Sokrates — February 27, 2010 @ 7:18 pm BST Feb 27,2010 | Reply

    • 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.

      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 BST Feb 28,2010 | Reply

  2. I can’t find a cached copy of Tom’s code, but I did find this., Print table with dynamic query:

    Comment by Mark — February 27, 2010 @ 11:55 pm BST Feb 27,2010 | Reply

    in sqlplus — how can you do that? well — click here: 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

    Comment by Sokrates — February 28, 2010 @ 2:30 pm BST Feb 28,2010 | Reply

  4. Hi Jonathen,

    In free space report scripts (, 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) ?


    Comment by Vineeth Kalanthodi — March 8, 2010 @ 4:59 pm BST Mar 8,2010 | Reply

RSS feed for comments on this post.

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by