/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

7 votes157 views1 answer
Query postgres delete duplicates
SQL
7 votes144 views3 answers
Postgresql dump and restore db
SQL
0 vote181 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote168 views1 answer
SQL Query to delete all the tables in a database
SQL
-1 vote149 views1 answer
Ssql to lowercqse
SQL
4 votes156 views2 answers
Oracle default date format
SQL
1 vote161 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
4 votes190 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote255 views1 answer
How to get all values in a table mysql in c#
SQL
1 vote149 views1 answer
Python escape mysql
SQL