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