可以找出已执行还没有提交的事物。

select
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';