转储进程状态:
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 '
2.heapdump_addr:转储subheap
SQL> alter session set events 'immediate trace name heapdump_addr '
3.row_cache:转储dictionary cache
SQL> alter session set events 'immediate trace name row_cache level '
4.buffer:转储buffer cache
SQL> alter sessiaon set events 'immediate trace name buffers level '
5.library_cache:转储library cache
SQL> alter session set events 'immediate trace name library_cache level ';

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

：

您可能感兴趣的文章: