查看锁

select SESS_ID,SESS_SEQ,SQL_TEXT,STATE, CREATE_TIME from v$sessions where trx_id in (select trx_id from V$LOCK);

解锁

SP_CLOSE_SESSION(会话 ID);