看看options表是否有未提交的事务

select t1.user_name,
       t1.sess_id,
       t1.sql_text,
       t1.state,
       t1.trx_id,
       T2.INS_CNT,
       T2.DEL_CNT,
       T2.UPD_CNT
  from v$sessions t1,
       v$trx t2
where t1.trx_id=t2.id
   and t1.state='IDLE'
   AND T2.STATUS='ACTIVE';

--使用结果集的SQL清除
SELECT 'SP_CLOSE_SESSION('||SESS_ID||');' FROM V$SESSIONS WHERE TRX_ID IN (SELECT WAIT_FOR_ID FROM V$TRXWAIT);
SELECT 'SP_CLOSE_SESSION('||SESS_ID||');' FROM V$SESSIONS S, V$LOCK L WHERE S.TRX_ID = L.TRX_ID AND L.BLOCKED = 1;
--或者根据SESS_ID清除
SP_CLOSE_SESSION(SESS_ID);
--如果清除不掉，先取消，再清除
SP_CANCEL_SESSION_OPERATION(SESS_ID);
SP_CLOSE_SESSION(SESS_ID);