Re: CR Block copies, always 6 in 10.2.0.3?

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: