[Oracle Script] Rollback Segment Usage

SELECT s.sid, s.serial# serial, s.module, s.program, s.status session_status, t.status txn_status, t.start_time start_time,
       r.name rbs, t.used_urec undo_records, t.used_ublk, t.log_io txn_logical_io,  t.phy_io txn_physical_io, t.cr_get txn_consistent_gets,
       t.cr_change txn_consistent_changes, s.event, sql.sql_text
  FROM v$transaction t, v$rollname r, v$session s, v$sql sql
 WHERE s.taddr = t.addr AND r.usn = t.xidusn and s.sql_id=sql.sql_id 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-2143821/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-2143821/