Re: CR Block copies, always 6 in 10.2.0.3?

What about timeouts vs posted?

Op 3/30/08 2:48 PM, kyle Hailey <kylelf_at_gmail.com> schreef:

> 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
> /

--
http://www.freelists.org/webpage/oracle-l