Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/08/20(13:24) from 210.93.7.51 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2803 , ÁÙ¼ö : 26 |
[Oracle] table lock session kill |
---|
SQL> SELECT DISTINCT t1.session_id AS session_id ,t2.serial# AS serial_no ,t1.os_user_name AS os_user_name ,t1.oracle_username AS oracle_username ,t2.status AS status ,t3.object_name ,DECODE( locked_mode ,2, 'ROW SHARE' ,3, 'ROW EXCLUSIVE' ,4, 'SHARE' ,5, 'SHARE ROW EXCLUSIVE' ,6, 'EXCLUSIVE' ,'UNKNOWN' ) lock_mode FROM v$locked_object t1, v$session t2, dba_objects t3 WHERE t1.session_id = t2.SID AND t1.object_id = t3.object_id; @ »ç¿ë¹ý 2°³ ÀÎÀÚ ÁÜ SESSION_ID, SERIAL_NO SQL> alter system kill session '1400,67'; |