Re: Subject: Batch load freezes every couple of minutes
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: mosicr@xxxxxxxxxx
- Date: Sun, 17 Apr 2005 22:20:56 -0400
Ranko Mosic wrote:
>
>My tests show that Waits ( total_wait# ) only gets increased when there =
>is row level lock contention ( session is waiting for commit/rollback =
>from the other session ). Average wait time calculated from =
>v$system_event for 'enqueue' is very small.=20
>Could this high figure for total_wait# be the reason why load freezes ?=20
>
>( Checkpoint not complete are the problem, but I am now looking beyond =
>that ).
>
>Regards, Ranko.=20
>
>
Ranko, V$SYSSTAT is not entirely adequate table for your purpose. May be
you should look into V$SESSION_WAIT,
as these waits are happening or V$SESSION_EVENT, to see what the session
was waiting on since its start. You can
also try writing a login trigger that would execute something like
'DBMS_SYSTEM.SET_EV(sid,serial#,10046,8,'BDBAFH');
and then analyze the resulting trace file.
--
Mladen Gogala
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
