Re: buffer cache

[George Schlossnagle]

select
obj.name,
trunc(count(*)*100/vp.value,2) percentage
from
sys.x$bh bh,
sys.obj$ obj,
(select value from v$parameter where name = 'db_block_buffers') vp
where
bh.obj = obj.dataobj#
group by
obj.name,
value
order by
percentage desc;


will work (at least under 8i and 9i).

On Tuesday, June 11, 2002, at 09:08 PM, BigP wrote:

Hi Guys ,
IS there any way I can find what is occupying how much of buffer cache . Like .. what table is taking most of space etc .
Thanks ,
Bp

// George Schlossnagle
// Principal Consultant
// OmniTI, Inc http://www.omniti.com
// (c) 301.343.6422 (e) [EMAIL PROTECTED]
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0