Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: buffer busy waits
I know a couple ...
kdsgrp => get row piece (fetch from chained/migrated rows or table with more
than 255 columns)
kdifind => find the leaf block associated with the key
kdiixs => index range scan
I hope this hasn't changed.
Raj
On 8/1/05, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_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 CALLS WAITS CAUSED WAITS
> ------------------------- ---------- ---------- ------------
> kdiwh09: kdiixs 191398675 0 95239
> kdiwh22: kdifind 32024815 0 177736
> kdswh05: kdsgrp 2.9645E+10 0 2515451
>
> I searched Metalink and Google to no avail.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 01 2005 - 14:24:08 CDT
![]() |
![]() |