From oracle-l-bounce@freelists.org Tue May 10 09:15:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4AEF6Zn023856 for ; Tue, 10 May 2005 09:15:06 -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 j4AEF64Z023852 for ; Tue, 10 May 2005 09:15:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4FF4E1917C7; Tue, 10 May 2005 08:12:25 -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 27565-07; Tue, 10 May 2005 08:12:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA140191C5E; Tue, 10 May 2005 08:12:24 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PnvLZ2upxOotAkYjsm80Wl542NMp6uaSDGvdvhirFEtCbXR4hbjGJsKu96no+53RBZZnPAcH3yhKmx9Swwa1l6YyURyZy4VTXbvKNO9yFF2l9vgl9nKrIelX3cKFJ0mk2Wkp7Xvq1jl95zhqoOH2JTG4gtc8kBD6Y/Ze4l5iqTI= Message-ID: <3b0f44a105051006104c1c6dfb@mail.gmail.com> Date: Tue, 10 May 2005 15:10:36 +0200 From: K Gopalakrishnan To: sjaffarhussain@gmail.com Subject: Re: buffer busy waits PUZZLES Cc: "oracle-l@freelists.org" In-Reply-To: <97b7fd2f05051005419e40b7b@mail.gmail.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <97b7fd2f05051005419e40b7b@mail.gmail.com> X-archive-position: 19508 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kaygopal@gmail.com Precedence: normal Reply-To: kaygopal@gmail.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.0 required=5.0 tests=none autolearn=ham version=2.63 Jaffar: What is the most common reason code (p3=3D?) you are noticing? Tracing the sessions with 10046^8 will give you more information about the type of the block and the reason code for buffer busy wait.. (btw the waits are 'buffer busy waits' WAIT or 'buffer busy' WAIT?) If it is 'buffer busy' WAITs then the issue may not be with freelists. --=20 Best Regards, K Gopalakrishnan=20 Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ -- http://www.freelists.org/webpage/oracle-l