Introduction to common Oracle dump commands

1. MemoryDumps1). GlobalAreaALTERSESSIONSETEVENTS

1. Memory Dumps 1). Global Area ALTER SESSION SET EVENTS

1. Memory Dumps

1). Global Area

Alter session set events 'immediate trace name global_area level n ';

1 Including PGA
2 contains SGA
4 include UGA
8 contains indrect memory

2). Library Cache

Alter session set events 'immediate trace name library_cache level n ';

1. library cache statistics
2 contains hash table histogram
3 include object handle
4 contains the 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 the 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
10 level 6 + users/waiters

5). Buffer

Alter session set events 'immediate trace name buffer level n ';

N is the rdba of a specified block. This command can be used to dump all versions of a block in the buffer.

6). Heap

Alter session set events 'immediate trace name heapdump level level ';

1 PGA Summary
2 SGA Abstract
4 UGA Summary
8 Current call (CGA) Abstract
16 User call (CGA) Abstract
32 Large call (LGA) Abstract
1025 PGA content
2050 SGA content
4100 UGA content
8200 Current call content
16400 User call content
32800 Large call content

7). Sub Heap

Before Oracle 9.0.1

Alter session set events 'immediate trace name heapdump_addr level n ';

If n is the subheap address, the digest information of the subheap is dumped.
If n is the subheap address + 1, the dumped content is the subheap content.

Versions later than Oracle 9.2.0

Alter session set events 'immediate trace name heapdump_addr level n, addr m ';

M is the subheap address.

N is the digest of 1 dump subheap, n is the content of 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
3. Workarea Table details

13). Latches

Alter session set events 'immediate trace name latches level n ';

1. latch Information
2. Statistics

14). Events

Alter session set events 'immediate trace name events level n ';

1 session
2 process
3 system