Oracle: v$bh - who is using buffer cache?
column c0 heading 'Owner' format a15column c1 heading 'ObjectName' format a30
column c2 heading 'NumberofBuffers' format 999,999
column c3 heading 'Percentageof DataBuffer' format 999,999,999
select
owner c0,
object_name c1,
count(1) c2,
(count(1)/(select count(*) from v$bh)) *100 c3
from
dba_objects o,
v$bh bh
where
o.object_id = bh.objd
and
o.owner not in ('SYS','SYSTEM','AURORA$JIS$UTILITY$')
group by
owner,
object_name
order by
count(1) desc
;
posted by James Pei @ 10:29 PM
1 Comments:
check out the correction of Jonathan Lewis for joinin v$bh and dba_objects over data_object_id instead of object_id
http://jonathanlewis.wordpress.com/2006/11/02/but-its-in-the-manual/
Post a Comment
<< Home