Oracle Common Dump command, record for reference. _oracle

I. Memory dumps

1). Global Area
ALTER session SET EVENTS ' immediate trace name Global_area level n ';
1 contains PGA
2 contains SGA
4 contains UGA
8 contains indrect memory

2). Library Cache
ALTER session SET EVENTS ' immediate trace name Library_cache level n ';
1 Library Cache statistic Information
2 contains hash table histogram
3 contains object handle
4 contains object structure (Heap 0)

3). Row Cache
ALTER session SET EVENTS ' immediate trace name Row_cache level n ';
1 Row Cache Statistics
2 contains hash table histogram
8 contains object structure

4). Buffers
ALTER session SET EVENTS ' immediate trace name buffers level n ';
1 Buffer Header
2 Level 1 + block header
3 Level 2 + block contents
4 Level 1 + hash chain
5 Level 2 + hash chain
6 Level 3 + hash chain
8 Level 4 + users/waiters
9 Level 5 + users/waiters
Ten Level 6 + users/waiters

5). Buffer
ALTER session SET EVENTS ' immediate trace name buffer level n ';
N is the rdba of a specified block, which dumps all versions of a block in buffer.

6). Heap
ALTER session SET EVENTS ' immediate trace name heapdump level level ';
1 PGA Summary
2 SGA Summary
4 UGA Summary
8 Current Call (CGA) Summary
User Call (CGA) Summary
Large Call (LGA) Summary
1025 PGA Content
2050 SGA Content
4100 UGA Content
8200 Current Call content
16400 User Call Content
32800 Large Call Content

7). Sub Heap
Prior to Oracle version 9.0.1
ALTER session SET EVENTS ' immediate trace name heapdump_addr level n ';
If n is a subheap address, dumps the Subheap summary information
If n is the Subheap address +1, the dump is the SUBHEAP content
After Oracle version 9.2.0
ALTER session SET EVENTS ' immediate trace name heapdump_addr level n, addr m ';
where M is the address of subheap
N is the summary of the 1 dump SUBHEAP, n is the contents of the 2 dump Subheap

8). Process State
ALTER session SET EVENTS ' immediate trace name processstate level n ';

9). System State
ALTER session SET EVENTS ' immediate trace name systemstate level n ';

10). Error State
ALTER session SET EVENTS ' immediate trace name Errorstack level n ';
0 Error Stack
1 Level 0 + function call stack
2 Level 1 + process state
3 Level 2 + context area
11). Hang Analysis
ALTER session SET EVENTS ' immediate trace name Hanganalyze level n ';

12). Work Area
ALTER session SET EVENTS ' immediate trace name workareatab_dump level n ';
1 SGA Information
2 Workarea Table Summary information
3 Workarea Table Details

13). Latches
ALTER session SET EVENTS ' immediate trace name latches level n ';
1 Latch Information
2 Statistic Information

14). Events
ALTER session SET Events ' immediate trace name events level n ';
1 session
2 process
3 system

15). Locks
ALTER session SET EVENTS ' immediate trace name locks level n ';

16). Shared Server Process
ALTER session SET EVENTS ' immediate trace name shared_server_state level n ';
n takes a value of 1~14

17). Background Messages
ALTER session SET EVENTS ' immediate trace name bg_messages level n ';
N is pid+1

Two. File dumps

1). Block
Oracle 7 ago
ALTER session SET EVENTS ' immediate trace name blockdump level n ';
N is the RDBA of block
After Oracle8
ALTER SYSTEM DUMP datafile file# block block#;
ALTER SYSTEM DUMP datafile file#
Block MIN minimum_block#
Block MAX maximum_block#;

2). Tree Dump
ALTER session SET EVENTS ' immediate trace name treedump level n ';
N is object_id

3). Undo Segment Header
ALTER SYSTEM DUMP undo_header ' segment_name ';

4). Undo for a Transaction
ALTER SYSTEM DUMP UNDO block ' segment_name ' XID xidusn xidslot xidsqn;

5). File Header
ALTER session SET EVENTS ' immediate trace name File_hdrs level n ';
1 file header information in the control file
2 Level 1 + file header information
3 level 2 + data file header information
Ten Level 3

6). Control file
ALTER session SET EVENTS ' immediate trace name Controlf level n ';
1 File header information
2 Level 1 + database information + checkpoint information
3 Level 2 + Reusable Section information
Ten Level 3

7). Redo Log Header
ALTER session SET EVENTS ' immediate trace name REDOHDR level n ';
1 redo log information in the control file
2 Level 1 + file header information
3 level 2 + log file header information
Ten Level 3

8). Redo Log
ALTER SYSTEM DUMP LOGFILE ' FileName ';
ALTER SYSTEM DUMP LOGFILE ' FileName '
SCN MIN MINIMUMSCN
SCN MAX MAXIMUMSCN
Time MIN Minimumtime
Time MAX Maximumtime
LAYER LAYER
OPCODE OPCODE
DBA MIN filenumber. Blocknumber
DBA MAX filenumber. Blocknumber
RBA MIN Logfilesequencenumber. Blocknumber
RBA MAX Logfilesequencenumber. Blocknumber;
Where time = (((yyyy-1988) * + mm-1) * + dd-1) * + hh) * + mi) * + SS;

9). Loghist
ALTER session SET EVENTS ' immediate trace name loghist level n ';
The earliest and latest log history items in the 1 dump control file
1 Dump 2^n Log History item