Oracle's Common Dump

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.