cache dump

Diagnostics: Library Cache Dump
------------------------------------
SQL> alter session set events 'immediate trace
  2  name library_cache level 4';

Oracle9i Release 2 level values:
Level 1:   Dump library cache statistics
Level 2:   Dump hash table summary
Level 4:   Dump library cache objects, basic information
Level 8:   Dump objects with detailed information
Level 16:  Dump heap sizes (can be latch intensive)
Level 32:  Dump heap information

 

--DUMP buffer CACHE
alter session set events 'immediate trace name buffers level 1';

        
1.dump buffer header
2.1+block header
3.2+block内容
4.dump buffer header & hash chain
5.1+dump block header &hash chain (1+4)
6.2+dump block header &hash chain (2+4)
8.dump buffer header & hash chain+ user list+waiter list
9.1+dump block header & hash chain+ user list+waiter list
10.2+dump block内容+hash chain+ user list+waiter list

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20709695/viewspace-708220/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20709695/viewspace-708220/