Re: Subject: Batch load freezes every couple of minutes

From: Ranko Mosic <mosicr_at_rogers.com>
Date: Tue, 19 Apr 2005 22:05:51 -0400
Message-ID: <00ba01c5454d$7aba3870$54369c18@vv4xpaygpndtkd>

Wish I could, load is finished now. Ran utllockt, got nothing back.

Original Message ----- From: "sol beach" <sol.beach_at_gmail.com> To: "Ranko Mosic" <mosicr_at_rogers.com> Cc: <oracle-l_at_freelists.org>; <ryan_gaffuri_at_comcast.net> Sent: Tuesday, April 19, 2005 7:42 PM Subject: Re: Subject: Batch load freezes every couple of minutes

Run this query when the "hang" is happening

SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,

         id1, id2, lmode, request, type
    FROM V$LOCK
   WHERE (id1, id2, type) IN

(SELECT id1, id2, type FROM V$LOCK WHERE request>0) ORDER BY id1, request
/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 19 2005 - 22:05:25 CDT