/SQL/How to check rollback status in oracle

How to check rollback status in oracle

-- Informations on rollbacks
SELECT s.USERNAME, s.SID, s.SERIAL#, t.USED_UBLK, t.USED_UREC, rs.SEGMENT_NAME,
       r.RSSIZE, r.STATUS
FROM V$TRANSACTION t,
     V$SESSION s,
     V$ROLLSTAT r,
     DBA_ROLLBACK_SEGS rs
WHERE s.SADDR = t.SES_ADDR
  AND t.XIDUSN = r.USN
  AND rs.SEGMENT_ID = t.XIDUSN
ORDER BY t.USED_UBLK DESC;

Source: oracle-base.com

Similar codes

18 votes149 views6 answers
Drop table if exists
SQL
0 vote146 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
8 votes143 views3 answers
Oracle auto_increment
SQL
22 votes149 views4 answers
Mysql reset auto increment id
SQL
0 vote138 views1 answer
View acl table oracle
SQL
0 vote140 views1 answer
Resulting Query
SQL
0 vote150 views1 answer
Psql list view rules
SQL
0 vote253 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote148 views1 answer
Hive batch drop table
SQL
-1 vote143 views2 answers
Get day in sql
SQL