From oracle-l-bounce@freelists.org Wed May 25 04:28:33 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4P9SXbu012030 for ; Wed, 25 May 2005 04:28:33 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4P9SXNi012026 for ; Wed, 25 May 2005 04:28:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFF2F1B20A3; Wed, 25 May 2005 03:25:36 -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 07347-10; Wed, 25 May 2005 03:25:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47E241B1FCB; Wed, 25 May 2005 03:25:36 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=KyR6op/mIuwjyjAiLqRmgyc4cijBu3EJ29kp3pdeteOpm4kLOSUxoEj9N3ITalMj2vbiTVVD5Rqj313/aJgsJ2+A3OmEIuxPR8IBUiz4J3LwASWeFEb5s3cl8BYi7H3t8Xf5H1uDH8dTsCQjymJvUXK9CIJbiAeO+x4Zi12dKeE= ; Message-ID: <20050525082344.17198.qmail@web52602.mail.yahoo.com> Date: Wed, 25 May 2005 01:23:44 -0700 (PDT) From: Martic Zoran Subject: RE: sequential read on full-table scan? To: Oracle-L@freelists.org In-Reply-To: 6667 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 20233 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zoran_martic@yahoo.com Precedence: normal Reply-To: zoran_martic@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.6 required=5.0 tests=AWL,FIND_ANYTHING, FORGED_YAHOO_RCVD autolearn=no version=2.63 Cary, Thank you a lot. I could not cover all test cases yesterday so easy because of no time and non-easy ways to trace parallel slave processes. So I asked you/oracle-l list. I just wanted to get more info about the direct path read associating with the parallel slaves from the master. What is on the net is very scattered and in some cases wrong. Also, very hard to find out anything about it except usual copied sentences from Oracle docs. But it looks my old knowledge about it did not change. So all blocks are going always to the PGA regardless of the cache. Regards, Zoran --- Cary Millsap wrote: > I suspected that saying "never" might get me into > trouble. :) > > I think that 2 is false for direct path read, > because I believe that direct > path reads are not buffer cache managed. I should > have said, more precisely, > "Oracle will never PIO a block /into the buffer > cache/ that's already in the > buffer cache." > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > * Nullius in verba * __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ -- http://www.freelists.org/webpage/oracle-l