Oracle Database ã® enqueue(ããã¯) ã® å¾ æ©ããã¦ããæ¹(ãã«ãã¼) ã¨ å¾ æ©ãã¦ããæ¹(ã¦ã§ã¤ã¿ã¼)ãåºåããã«ã¯ãV$LOCKãã¥ã¼ãåç §ãã¾ãã以ä¸ã® SQL ãå®è¡ãã¾ãã SET LINESIZE 300; COLUMN SESS FORMAT A20; 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; åºåä¾ã«ã¤ãã¦ãã¾ãã¯ä»è¾¼ã¿ã§ããTBL_X表ã®åä¸ã¬ã³ã¼ãã è¤æ°ã»ãã·ã§ã³ããæ´æ°ãã¦ãè¡ã
{{#tags}}- {{label}}
{{/tags}}