需要先找到导致问题的session

t1.sql_text,
t1.state ,
t1.trx_id
from
v$sessions t1,
v$trx t2
where
t1.trx_id=t2.id
and t1.state ='IDLE'
and t2.status='ACTIVE';

执行一下看看

通过以下语句查询是否有该表相关的未提交事务：
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'；