Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

Re: buffer busy waits

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: Brandon.Allen@xxxxxxxxxxx
  • Date: Mon, 1 Aug 2005 15:20:53 -0400
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> 
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.
> 
>

Other related posts:

  • buffer busy waits
  • Re: buffer busy waits
  • Re: buffer busy waits
  • RE: buffer busy waits
  • RE: buffer busy waits
  • RE: buffer busy waits
  • Re: buffer busy waits
  • RE: buffer busy waits
  • buffer busy waits
  • Re: buffer busy waits




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.