/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

0 vote275 views1 answer
Two inner joins sql
SQL
16 votes268 views4 answers
Mysql import from sql file
SQL
0 vote264 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
17 votes283 views6 answers
What is cursor in sql server with example
SQL
1 vote301 views1 answer
Get current date in pyspark sql
SQL
11 votes266 views4 answers
Round in sql
SQL
0 vote275 views1 answer
Postgres read table structure
SQL
5 votes254 views1 answer
How to check nls timestamp format in oracle
SQL
21 votes287 views1 answer
SQL cheat sheet pdf
SQL
0 vote282 views1 answer
Oracle query archive mode
SQL