oracle 数据库 使用kill session 表解锁

1、先执行下面查询语句，查看哪些被锁

SELECT OBJECT_ID,       SESSION_ID,       SERIAL#,       ORACLE_USERNAME,       OS_USER_NAME,       S.PROCESS  FROM V$LOCKED_OBJECT A, V$SESSION S WHERE A.SESSION_ID = S.SID;

2、执行解锁语句

alter system kill session 'SESSION_ID,SERIAL#';