From oracle-l-bounce@freelists.org Fri May 20 15:02:07 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4KK27g2027141 for ; Fri, 20 May 2005 15:02:07 -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 j4KK264Z027137 for ; Fri, 20 May 2005 15:02:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A4EB7195E84; Fri, 20 May 2005 13:59:14 -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 25040-06; Fri, 20 May 2005 13:59:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 29A86195EFD; Fri, 20 May 2005 13:59:14 -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=i0B6Rx9+gDjvUA3FPuOaLNTAXAF/dFGntLye9jER3SMkeX+r4HkXWskDLLTghFtEm+lpUhyqLIL4JqrQESf2ojkmyoU2ucwdFwxsITfYOPlz29GWlw9hRFm65Qw5lTtmaLvBiq3ErYg+ZZV0gdMmXZVSSBCBWpx+EQccRlxkXhU= ; Message-ID: <20050520185724.74110.qmail@web52604.mail.yahoo.com> Date: Fri, 20 May 2005 11:57:24 -0700 (PDT) From: Martic Zoran Subject: Re: sequential read on full-table scan? To: paul.baumgartel@gmail.com Cc: 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: 20034 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.5 required=5.0 tests=AWL,FORGED_YAHOO_RCVD autolearn=no version=2.63 Paul, I believe if you trace the SQL with 10046 level 8 a little bit that p2 value for db file sequential reads are not going to be one after the other, so proving that fact 3 + sometimes fact 2 from what Christian said is true. Of course my assumption that block id's are increasing inside the file (p1 values) should be true :) Regards, Zoran Martic --- Paul Baumgartel wrote: > Christian, > > The third point you made might be relevant here. > There's pretty much > no other activity on this instance; maybe the buffer > cache is filled > with blocks from this table, and Oracle just reads > in single blocks as > needed. I suppose that's more efficient than > reading in the same > blocks over and over in multi-block reads. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l