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';