Re: CR Block copies, always 6 in 10.2.0.3?

From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
To: "kyle Hailey" <kylelf@xxxxxxxxx>
Date: Sun, 30 Mar 2008 17:59:21 -0500

Kyle,

What is the  value of _buffer_busy_wait_timeout in your database?

-Gopal



On Sun, Mar 30, 2008 at 8:48 AM, kyle Hailey <kylelf@xxxxxxxxx> wrote:
> I was wondering about the 1sec timout on buffer busy waits. Scanning
> v$active_session_history it doesn't look like the timeouts are 1 sec.
> They seem  fairly evenly distributed between 0 - 1 sec:
>
>  COUNT(*) TIME_WAITED_SECS
> ---------- ----------------
>        30                0
>        24               .1
>        30               .2
>        35               .3
>        35               .4
>        17               .6
>        15               .7
>        13               .8
>        64               .9
>        28                1
>
> select
>       count(*),
>       trunc(time_waited/100000)*.1 time_waited_secs
> from v$active_session_history ash
> where
>   event='buffer busy waits'
>   and ash.session_state='WAITING'
> group by
>       trunc(time_waited/100000)*.1
> order by
>       trunc(time_waited/100000)*.1
> /
>



-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
//www.freelists.org/webpage/oracle-l

References:
- Re: CR Block copies, always 6 in 10.2.0.3?
  - From: K Gopalakrishnan
- Re: CR Block copies, always 6 in 10.2.0.3?
  - From: Anjo Kolk
- Re: CR Block copies, always 6 in 10.2.0.3?
  - From: 조동욱
- Re: CR Block copies, always 6 in 10.2.0.3?
  - From: kyle Hailey

Re: CR Block copies, always 6 in 10.2.0.3?

Other related posts: