Untitled Document

Oracle Internals

Dumps

To dump the redo log headers

    ALTER SESSION SET EVENTS 'immediate trace name redohdr level 1';

Levels (circa Oracle 8.1.5) are

Level	Description
1	Dump redo log entry from control file
2	Level 1 + generic file header
3	Level 2 + log file header
10	Same as level 3

The following ORADEBUG command has the same effect

    ORADEBUG DUMP REDOHDR level