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@xxxxxxxxx> 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


Other related posts: