Dumps
Controlfiles
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
|