Re: Subject: Batch load freezes every couple of minutes

  • From: sol beach <sol.beach@xxxxxxxxx>
  • To: Ranko Mosic <mosicr@xxxxxxxxxx>
  • Date: Tue, 19 Apr 2005 16:42:05 -0700

Run this query when the "hang" is happening

SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,=20
         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:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2005