ITPub博客

首页 > Linux操作系统 > Linux操作系统 > cache dump

cache dump

原创 Linux操作系统 作者:冷月逐浪 时间:2011-09-23 21:35:56 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-07-10

  • 博文量
    42
  • 访问量
    82841