oracle数据库锁表处理

第一步：找出被锁表对应的session_id

SELECT B.OWNER, B.OBJECT_NAME, A.SESSION_ID, A.LOCKED_MODE FROM V$LOCKED_OBJECT A, DBA_OBJECTS B WHERE B.OBJECT_ID = A.OBJECT_ID;

第二步：根据上一步查出来的session_id找出对应的SERIAL#

SELECT B.USERNAME, B.SID, B.SERIAL#, LOGON_TIME FROM V$LOCKED_OBJECT A, V$SESSION B WHERE A.SESSION_ID = B.SID ORDER BY B.LOGON_TIME;

第三步：杀掉锁了的进程

ALTER SYSTEM KILL SESSION 'session_id,SERIAL#';