oracle表被鎖

SELECT OBJECT_ID, SESSION_ID, LOCKED_MODE FROM V$LOCKED_OBJECT;

SELECT T2.USERNAME, T2.SID, T2.SERIAL#, T2.LOGON_TIME

FROM V L O C K E D O B J E C T T 1 , V LOCKED_OBJECT T1, V LOCKEDO​BJECTT1,VSESSION T2

WHERE T1.SESSION_ID = T2.SID

ORDER BY T2.LOGON_TIME;

殺掉session

alter system kill session ‘2767,18895’;