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

6 Comments »

  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.

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

  2. 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 BST Feb 27,2010 | Reply

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

  4. 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 BST Mar 8,2010 | Reply


RSS feed for comments on this post.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 3,528 other followers