Lock 걸린 Object 찾는 sql
SELECT a.SID , a.serial# , a.process , b.owner , b.object_name , DECODE (c.TYPE, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) "LOCK LEVEL" , DECODE (c.lmode, 2, 'RS', 3, 'RX', 4, 'S', 5, 'SRX', 8, 'X', 'NO') "LOCK MODE" , DECODE (a.command, 2, 'INSERT', 3, 'SELECT', 6, 'UPDATE', 7, 'DELETE', 12, 'DROP TABLE', 26, 'LOCK TABLE', 'Unknown') "SQL" , a.state , TRIM (TO_CHAR (TRUNC (c.ctime / 3600, 0),..