oracle 查询DB事务

select SQL_TEXT from v$sql,v$transaction where LAST_ACTIVE_TIME=START_DATE

看看是哪个sql 运行后，事物没有提交

select * from v$transaction

select sess.sid, 
sess.serial#, 
lo.oracle_username, 
lo.os_user_name, 
ao.object_name, 
lo.locked_mode 
from v$locked_object lo, 
dba_objects ao, 
v$session sess 
where ao.object_id = lo.object_id and lo.session_id = sess.sid; 

-- DB 事务，session的设置情况

 select * from v$resource_limit where resource_name in ('processes', 'sessions', 'transactions');