oracle程式和記憶體轉儲說明

selectshen發表於2016-02-25
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28539951/viewspace-1994674/，如需轉載，請註明出處，否則將追究法律責任。

相關文章