#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博客

what's mean about db_block_hash_buckets and others?

最新文章