Re: Do selects block truncates?

  • From: "sol beach" <sol.beach@xxxxxxxxx>
  • To: krish.hariharan@xxxxxxxxxxxx
  • Date: Thu, 20 Dec 2007 19:23:00 -0800

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
/

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2007