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博客

[Oracle Script] Rollback Segment Usage

最新文章