Re: buffer cache

From: George Schlossnagle <george_at_omniti.com>
Date: Tue, 11 Jun 2002 19:28:23 -0800
Message-ID: <F001.0047B681.20020611192823@fatcity.com>

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) george_at_omniti.com
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: george_at_omniti.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 11 2002 - 22:28:23 CDT