Oracle Scratchpad

August 10, 2009


Filed under: Troubleshooting — Jonathan Lewis @ 10:37 pm BST Aug 10,2009

Here’s an interesting tale from Arup Nanda (of Oracle Magazine fame) of how to examine the hanganalyze report, including a note telling you about the undocumented: “sqlplus -prelim /nolog”  for those times when you can’t even connect to the instance to run the hanganalyze command.


  1. What a coincidence , four months (24-APR-2008) before above blog post. I have blog similar post.

    Comment by anunet — August 11, 2009 @ 3:41 am BST Aug 11,2009 | Reply

  2. Wow, I was not aware of the “set _prelim on” command.

    It even shows the option being set by the SHOW command:

    SQL> show _prelim
    _prelim ON


    Comment by Arup Nanda — August 11, 2009 @ 5:42 pm BST Aug 11,2009 | Reply

    • Arup,

      Don’t you just love the way that a good blog or forum can help to collate useful information.
      Our group knowledge becomes more than the sum of our individual knowledge.

      Comment by Jonathan Lewis — August 11, 2009 @ 8:25 pm BST Aug 11,2009 | Reply

  3. […] una ricerca su Google sul’opzione -prelim di sqlplus, citata da Jonathan Lewis in un suo post (infatti ne aveva accennato qualche giorno prima, ma senza spiegare cosa fosse  Miladin Modrakovic […]

    Pingback by Variabili in SQL*Plus « Oracle and other — August 14, 2009 @ 1:31 pm BST Aug 14,2009 | Reply

  4. […] Jonathan Lewis sobre Hanganalyze. Realmete el no comenta nada, solo apunta a una entrada (antigua) de Arup […]

    Pingback by Entradas de Oracle semana 33 « Gruñidos sobre Oracle y SAP — August 23, 2009 @ 7:16 pm BST Aug 23,2009 | Reply

RSS feed for comments on this post. TrackBack URI

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 )

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.

Website Powered by

%d bloggers like this: