Re: Subject: Batch load freezes every couple of minutes
- From: "Ranko Mosic" <mosicr@xxxxxxxxxx>
- To: "sol beach" <sol.beach@xxxxxxxxx>
- Date: Tue, 19 Apr 2005 22:05:51 -0400
Wish I could, load is finished now. Ran utllockt, got nothing back.
----- Original Message -----
From: "sol beach" <sol.beach@xxxxxxxxx>
To: "Ranko Mosic" <mosicr@xxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>; <ryan_gaffuri@xxxxxxxxxxx>
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
/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
