Dumps

Hang Analysis

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

• systemstate level 1 dump
• processes currently waiting, blocking or spinning
• errorstacks

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