Re: Operations in huge transaction slow down suddenly. Why?

"Bernhard Graeuler" <fuerspam_at_gmx.de> wrote in message news:32ge68F3mhfnuU1_at_individual.net...
> Hi,

Run this SQL while the slowerdown is happening. If this return no rows then you don't have an enqueue problem.

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
/ Received on Fri Dec 17 2004 - 11:27:53 CST