转储进程状态:
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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28539951/viewspace-1994674/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28539951/viewspace-1994674/