Re: CR Block copies, always 6 in 10.2.0.3?

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_at_gmail.com> 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/
--
http://www.freelists.org/webpage/oracle-l