From oracle-l-bounce@freelists.org Wed Jul 7 12:30:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67HUV510556 for ; Wed, 7 Jul 2004 12:30:41 -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 i67HUK610529 for ; Wed, 7 Jul 2004 12:30:30 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3C67572CA7C; Wed, 7 Jul 2004 12:10:01 -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 03629-55; Wed, 7 Jul 2004 12:10:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9327C72CA6B; Wed, 7 Jul 2004 12:10:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 12:08:36 -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 C982972C8CC for ; Wed, 7 Jul 2004 12:08:35 -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 02308-81 for ; Wed, 7 Jul 2004 12:08:35 -0500 (EST) Received: from owa.metratech.com (mail.metratech.com [199.171.52.172]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 03EE172C8C7 for ; Wed, 7 Jul 2004 12:08:35 -0500 (EST) Received: from ex2003.metratech.com ([10.10.100.18]) by owa.metratech.com with Microsoft SMTPSVC(5.0.2195.5329); Wed, 7 Jul 2004 13:32:21 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: which Objects in buffer cache Date: Wed, 7 Jul 2004 13:32:21 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: which Objects in buffer cache Thread-Index: AcRkQmoMgWNYxpxUR+iceLLzEM8kVwABWQMw From: "Harvinder Singh" To: X-OriginalArrivalTime: 07 Jul 2004 17:32:21.0500 (UTC) FILETIME=[5BDF4BC0:01C46448] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4571 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Harvinder.Singh@MetraTech.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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 -----------------------------------------------------------------