Hang Analysis Dump

This dump is available in Oracle 8.0.6 and Oracle 8.1.6 and above. It is not available in Oracle 8.1.5:

It contains:

The HANGANALYZE dump is more selective than a SYSTEMSTATE dump in that it only includes details of processes of interest. It is particularly intended for situations where a database is hanging.

For example:

  ALTER SESSION SET EVENTS
  'immediate trace name hanganalyze level 5';

The following ORADEBUG command has the same effect:

  ORADEBUG DUMP HANGANALYZE level

e.g.:

  ORADEBUG DUMP HANGANALYZE 5

A HANGANALYZE dump can also be generated on an error e.g. when a deadlock is detected (ORA-00060) using the init.ora file:

  event = "60 trace name hanganalyze level 5"

or in the current session using:

  ALTER SESSION SET EVENTS
  '60 trace name hanganalyze level 5';