Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: which Objects in buffer cache

RE: which Objects in buffer cache

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 7 Jul 2004 14:27:05 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660B96@bosmail00.bos.il.pqe>


Mladen,

V$DB_OBJECT_CACHE is based on X$KGLOB, which is the library cache.

I believe the original poster was inquiring about contents of the buffer = cache, V$BH/X$BH.

-Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Wednesday, July 07, 2004 2:03 PM
To: oracle-l_at_freelists.org
Subject: Re: which Objects in buffer cache

On 07/07/2004 01:32:21 PM, Harvinder Singh wrote:
> Hi,

>=20

> We are using v$bh, dba_objects and dba_segments views to see what
> objects are in buffer cache.

Well, isn't that what the good lord Ellison has given us = V$DB_OBJECT_CACHE for?
As an added bonus, you even get the lock information.

--=20
Mladen Gogala
Oracle DBA



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jul 07 2004 - 13:23:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US