Skip to content

Oracle Hang analysis

Learning some new stuff every day. This one I discovered on Tanel Poder’s blog about Oracle Hang analysis.

The idea is the following:

oracle> sqlplus -prelim “/as sysdba”
SQL> ORADEBUG SETOSPID 
SQL> ORADEBUG DUMP HANGANALYZE 3

Then go to your trace file directory, and find the hanganalyze tracefile.

Post a Comment

Your email is never published nor shared. Required fields are marked *