How to dump the internal structure of the database

1. analyze data file blocks and dump data file n blocks m

Alter system dump datafile n block m

2. Analyze log files

Alter system dump logfile logfilename;

3. Analyze the Control File Content

Alter session set events 'immediate trace name CONTROLF level 10'

4. analyze all data file headers

Alter session set events 'immediate trace name FILE_HDRS level 10'

5. Analyze the Log File Header

Alter session set events 'immediate trace name REDOHDR level 10'

6. analyze the system status, preferably once every 10 minutes for three comparisons

Alter session set events 'immediate trace name SYSTEMSTATE level 10'

7. Analyze the Process status

Alter session set events 'immediate trace name PROCESSSTATE level 10'

8. Analyze the details of Library Cache

Alter session set events 'immediate trace name library_cache level 10'