oracle process state,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 '

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