oracle锁表解锁命令如下:

select distinct a from (SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS ,’alter system kill session ”’ || l.SESSION_ID || ‘,’ || s.SERIAL# || ”’;’ a
FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID);

执行该命令后,再次执行结果语句,即可解锁!