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.
August 10, 2009
6 Comments »
RSS feed for comments on this post. TrackBack URI
Oracle Scratchpad 
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 |
With a different way of using the “prelim” option, I see. I’ll take a closer look when I get a few minutes.
Comment by Jonathan Lewis — August 11, 2009 @ 6:14 am BST Aug 11,2009 |
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
SQL>
Cool!
Comment by Arup Nanda — August 11, 2009 @ 5:42 pm BST Aug 11,2009 |
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 |
[…] 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 |
[…] 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 |