Untitled Document

Oracle Internals

Dumps

To dump the current latch status use

    ALTER SESSION SET EVENTS 'immediate trace name controlf level level';

Levels (circa Oracle 8.1.5) are

Level	Description
1	Generic file header
2	Level 1 + database information + checkpoint progress records
3	Level 2 + reuse record section
10	Same as level 3

In later versions, level 15 appears to generate additional trace

The following ORADEBUG command has the same effect

    ORADEBUG DUMP CONTROLF level