From oracle-l-bounce@freelists.org Wed Jul 7 12:42:34 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67HgIj12983 for ; Wed, 7 Jul 2004 12:42:29 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i67Hg8612958 for ; Wed, 7 Jul 2004 12:42:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BBA0872CA39; Wed, 7 Jul 2004 12:23:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05421-55; Wed, 7 Jul 2004 12:23:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3F80372CA2D; Wed, 7 Jul 2004 12:23:20 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 12:21:56 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D5DE72C5F7 for ; Wed, 7 Jul 2004 12:21:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05807-05 for ; Wed, 7 Jul 2004 12:21:56 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E4C872C585 for ; Wed, 7 Jul 2004 12:21:56 -0500 (EST) Received: from aabo-exchange04.bos.il.pqe (aabo-exchange04.bos.il.pqe [172.24.3.67]) by tera.umi.com (8.12.10/8.12.10) with ESMTP id i67HivWo027607 for ; Wed, 7 Jul 2004 13:45:37 -0400 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by aabo-exchange04.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.0); Wed, 7 Jul 2004 13:45:52 -0400 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6556.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: which Objects in buffer cache Date: Wed, 7 Jul 2004 13:45:37 -0400 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFD37@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: which Objects in buffer cache Thread-Index: AcRkQmoMgWNYxpxUR+iceLLzEM8kVwABWQMwAABMuLA= From: "Bobak, Mark" To: X-OriginalArrivalTime: 07 Jul 2004 17:45:52.0732 (UTC) FILETIME=[3F6779C0:01C4644A] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4572 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Harvinder Singh Sent: Wednesday, July 07, 2004 1:32 PM To: oracle-l@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@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@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 -----------------------------------------------------------------