Re: CR Block copies, always 6 in 10.2.0.3?
From: kyle Hailey <kylelf_at_gmail.com>
Date: Sun, 30 Mar 2008 06:48:05 -0700
Message-ID: <6f373fd20803300648j5a5d3504q393a466caf026ece@mail.gmail.com>
where
Date: Sun, 30 Mar 2008 06:48:05 -0700
Message-ID: <6f373fd20803300648j5a5d3504q393a466caf026ece@mail.gmail.com>
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_secsfrom 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-lReceived on Sun Mar 30 2008 - 08:48:05 CDT