ITPub博客

首页 > Linux操作系统 > Linux操作系统 > what's mean about db_block_hash_buckets and others?

what's mean about db_block_hash_buckets and others?

原创 Linux操作系统 作者:tengrid 时间:2009-05-18 19:15:35 0 删除 编辑

#top 10 shared pool components
SQL> select * from
  2    (select name,bytes/(1024*1024) MB
     order by bytes desc)
  3       from v$sgastat
  4       where pool='shared pool'
  5       order by bytes desc)
  6  where rownum<11;

NAME                               MB
-------------------------- ----------
db_block_hash_buckets         16.8125   <--- what's mean?
free memory                11.4547272
kglsim object batch         10.144043   <--- what's mean?
library cache              8.79161835
ASH buffers                         8   <--- what's mean?
private strands            7.68457031   <--- what's mean?
CCursor                    7.59734344   <--- what's mean?
row cache                  7.13383484
sql area                   5.62482452
event statistics per sess  4.84405518   <--- what's mean?

10 rows selected.

 

I MUST understand large of important components of buffer/cache structures and various blocks!
of course,include the typical arithmetics

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

下一篇: about histogram(2)
请登录后发表评论 登录
全部评论

注册时间:2009-05-18

  • 博文量
    136
  • 访问量
    379127