lock 걸린 테이블 락 테이블 풀기

1. 락걸린 테이블 찾기

select a.sid, a.serial#,a.username,a.process,b.object_name,

decode(c.lmode,2,'RS',3,'RX',4,'S',5,'SRX',8,'X','NO') "TABLE LOCK",

decode (a.command,2,'INSERT',3,'SELECT',6,'UPDATE',7,'DELETE',12,'DROP TABLE',26,'LOCK TABLE','UNknown') "SQL",

decode(a.lockwait, NULL,'NO wait','Wait') "STATUS"

from v$session a,dba_objects b, v$lock c

where a.sid=c.sid and b.object_id=c.id1

and c.type='TM';

 

2. sid와 serial# 컬럼 확인후 세션 킬

ALTER SYSTEM KILL SESSION s.sid,s.serial#;

예) ALTER SYSTEM KILL SESSION '121,21';