Description of Oracle process and memory dump
Dump Process status:
SQL> alter session set events 'immediate trace name processstate level 10 ';
Or SQL> oradebug dump processstate 10
Dump system status:
SQL> alter session set events 'immediate trace name systemstate level 10 ';
The system status of the dump is divided into three parts:
1. Tracking File Header
2. Global System Information
3. Process Information
Dump memory can be divided:
1. heapdump: Dump PGA, SGA, UGA
SQL> alter session set events 'immediate trace name heapdump level <level>'
2. heapdump_addr: Dump subheap
SQL> alter session set events 'immediate trace name heapdump_addr <addr>'
3. row_cache: Dump dictionary cache
SQL> alter session set events 'immediate trace name row_cache level <level>'
4. buffer: Dump buffer cache
SQL> alter sessiaon set events 'immediate trace name buffers level <level>'
5. library_cache: Dump library cache
SQL> alter session set events 'immediate trace name library_cache level <level> ';
The dump memory is divided into three parts:
1. heap description
2. chunk In the extent list of heap
3. free lists, lru lists, permanent chunk lists, and marked chunk lists