RE: which Objects in buffer cache

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 7 Jul 2004 13:45:37 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFD37@bosmail00.bos.il.pqe>

Are you doing direct path insert?

When joining to V$BH/X$BH, were you careful to use = DBA_OJBECTS.DATA_OBJECT_ID rather than DBA_OBJECTS.OBJECT_ID?

-Mark

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Harvinder Singh Sent: Wednesday, July 07, 2004 1:32 PM
To: oracle-l_at_freelists.org
Subject: which Objects in buffer cache

Hi,

We are using v$bh, dba_objects and dba_segments views to see what objects are in buffer cache. We are reading from 1 table and inserting into 2nd table. I can see the 1st table but not the 2nd table in this query result.
I expect oracle to load data from disk to buffer and then write to buffers and should show the tables and indexes of 2nd table in buffer. What can be the possible reason that v$bh is not showing objects/segments of 2nd table?

Thanks
--Harvinder

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 12:42:34 CDT