Oracle查找没有提交事务的SQL

--查找没有commit的事务

select s.sid,s.serial#,'kill -9 ' || p.SPID, 'alter system disconnect session '''||s.sid||','||s.serial#||''' immediate;', s.status, s.LOGON_TIME,s.machine, t.start_time, a.SQL_ID, 

       a.SQL_TEXT, a.SQL_FULLTEXT, b.SQL_ID pre_sql_text, b.SQL_TEXT pre_sql_text, b.SQL_FULLTEXT,s.EVENT, a.rows_processed

from v$transaction t,v$session s,v$process p,v$sql a,v$sql b

where t.addr = s.taddr

and s.paddr = p.addr

and s.sql_id = a.sql_id(+)

and s.sql_child_number = a.child_number(+)

and s.prev_sql_id = b.sql_id(+)

and s.prev_child_number = b.child_number

order by t.start_time;