Re: CR Block copies, always 6 in 10.2.0.3?

  • From: "kyle Hailey" <kylelf@xxxxxxxxx>
  • To: ukja.dion@xxxxxxxxx
  • Date: Sun, 30 Mar 2008 06:48:05 -0700

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2008