轉儲程式狀態:
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

oracle程式和記憶體轉儲說明

相關文章