------------------------------------
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/