查找没有commit的事务

--查找没有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_processedfrom v$transaction t,v$session s,v$process p,v$sql a,v$sql bwhere t.addr = s.taddrand s.paddr = p.addrand 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_numberorder by t.start_time;