Oracle进程和内存转储说明

Oracle进程和内存转储说明

转储进程状态:
SQL> alter session set events 'immediate trace name processstate level 10';
或者SQL> oradebug dump processstate 10
 
转储系统状态:
SQL> alter session set events 'immediate trace name systemstate level 10';
 
转储的系统状态分三部分:
1.跟踪文件头
2.系统全局信息
3.进程信息

转储内存可分为:
1.heapdump:转储PGA, SGA, UGA
SQL> alter session set events 'immediate trace name heapdump level <level>'
2.heapdump_addr:转储subheap
SQL> alter session set events 'immediate trace name heapdump_addr <addr>'
3.row_cache:转储dictionary cache
SQL> alter session set events 'immediate trace name row_cache level <level>'
4.buffer:转储buffer cache
SQL> alter sessiaon set events 'immediate trace name buffers level <level>'
5.library_cache:转储library cache
SQL> alter session set events 'immediate trace name library_cache level <level>';

转储的内存分三部分:
1.heap的描述
2.heap的extent列表中的chunk
3.free lists, lru lists, permanent chunk lists,and marked chunk lists