Re: Subject: Batch load freezes every couple of minutes
- From: "Ranko Mosic" <mosicr@xxxxxxxxxx>
- To: "Mladen Gogala" <mgogala@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Apr 2005 22:00:46 -0400
I collected some v$session_wait, v$session_event output during the load.
Will analyze them further and see if it helps.
----- Original Message -----
From: "Mladen Gogala" <mgogala@xxxxxxxxxxxxxxxxxxxx>
To: <mosicr@xxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, April 17, 2005 10:20 PM
Subject: Re: Subject: Batch load freezes every couple of minutes
> 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:
