锁表清除session

 

1、select * from v$locked_object ; 获得 session_ID；

--2、select object_name, object_type from dba_objects where object_id = session_ID;--如果只是去删除session，可以省略这一步骤

 

3、select sid, serial#, machine, program from v$session where sid =session_ID

4、alter system kill session 'sid,serial#';