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