/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

2 votes138 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote126 views1 answer
Oracle index hint
SQL
1 vote153 views1 answer
Sql order by timestamp
SQL
0 vote141 views1 answer
How to locate pg_hba.conf file
SQL
0 vote143 views2 answers
How to type a blank discord messgae
SQL
17 votes128 views6 answers
Sql select distinct
SQL
0 vote139 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote134 views1 answer
Sql auto_increment syntax
SQL
8 votes136 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote127 views1 answer
Sqlalchemy.exc.OperationalError:
SQL