which Objects in buffer cache

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 7 Jul 2004 13:32:21 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D9254@ex2003.metratech.com>

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

---

Received on Wed Jul 07 2004 - 12:30:56 CDT