From oracle-l-bounce@freelists.org Mon Aug 1 14:24:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j71JO8k5001471 for ; Mon, 1 Aug 2005 14:24:08 -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 j71JNxIP001432 for ; Mon, 1 Aug 2005 14:24:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DB30D1DA2B5; Mon, 1 Aug 2005 14:23:55 -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 16973-07; Mon, 1 Aug 2005 14:23:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A59B31D9DC5; Mon, 1 Aug 2005 14:23:54 -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:references; b=XNPcfbvlaUuMMFvntz1nieCNTlsz05qRofWA8SVGCvinRrKKjuFDFQcD8l8VMDIrhZxifhn1YOFFIA+mefC61/rtWu9w46cT8v/q/PExol8HpswHlavrQbbZ3qB5kWuszl45vE8xXV/7D6m3mW5GUntm91wmC9XAdbQfUDl97C8= Message-ID: <9177895d0508011220294211b2@mail.gmail.com> Date: Mon, 1 Aug 2005 15:20:53 -0400 From: rjamya To: Brandon.Allen@oneneck.com Subject: Re: buffer busy waits Cc: "Bellows, Bambi" , john.kanagaraj@hds.com, kaygopal@gmail.com, oracle-l@freelists.org In-Reply-To: <04DDF147ED3A0D42B48A48A18D574C450236138B@NT15.oneneck.corp> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4436_19824867.1122924053922" References: <04DDF147ED3A0D42B48A48A18D574C450236138B@NT15.oneneck.corp> X-archive-position: 23130 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_4436_19824867.1122924053922 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I know a couple ...=20 kdsgrp =3D> get row piece (fetch from chained/migrated rows or table with m= ore=20 than 255 columns) kdifind =3D> find the leaf block associated with the key kdiixs =3D> index range scan I hope this hasn't changed. Raj On 8/1/05, oracle-l-bounce@freelists.org =20 wrote: >=20 > Yes, thank you KG, but I am wondering the same thing as Bambi. Here are= =20 > the top 3 functions output by the query you provided: >=20 > MODULE CALLS WAITS CAUSED WAITS > ------------------------- ---------- ---------- ------------ > kdiwh09: kdiixs 191398675 0 95239 > kdiwh22: kdifind 32024815 0 177736 > kdswh05: kdsgrp 2.9645E+10 0 2515451 >=20 > I searched Metalink and Google to no avail. >=20 > ------=_Part_4436_19824867.1122924053922 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I know a couple ...

kdsgrp =3D> get row piece (fetch from chained/migrated rows or table wit= h more than 255 columns)
kdifind =3D> find the leaf block associated with the key
kdiixs =3D> index range scan

I hope this hasn't changed.

Raj

On 8/1/05, oracle-l-bounce@freelis= ts.org <oracle-= l-bounce@freelists.org > wrote:
Yes, thank you KG, but I am wondering the same thing as Bambi.  Here are the top 3 functions output by the query you provided:

MODULE        &nbs= p;            &= nbsp;   CALLS      WAITS CAUSED WAITS
------------= ------------- ---------- ---------- ------------
kdiwh09: kdiixs           &nb= sp;191398675          0&n= bsp;       95239
kdiwh22: kdifind           &n= bsp;32024815          0&n= bsp;      177736
kdswh05: kdsgrp           2.9645E+10          0&nbs= p;     2515451

I searched Metalink and Goog= le to no avail.

------=_Part_4436_19824867.1122924053922-- -- http://www.freelists.org/webpage/oracle-l