how to check rollback status in oracle

Solutions on MaxInterview for how to check rollback status in oracle by the best coders in the world

Search
showing results for - "how to check rollback status in oracle"
Sacha
07 Feb 2020
1-- Informations on rollbacks
2SELECT s.USERNAME, s.SID, s.SERIAL#, t.USED_UBLK, t.USED_UREC, rs.SEGMENT_NAME,
3       r.RSSIZE, r.STATUS
4FROM V$TRANSACTION t,
5     V$SESSION s,
6     V$ROLLSTAT r,
7     DBA_ROLLBACK_SEGS rs
8WHERE s.SADDR = t.SES_ADDR
9  AND t.XIDUSN = r.USN
10  AND rs.SEGMENT_ID = t.XIDUSN
11ORDER BY t.USED_UBLK DESC;
source
similar questions
oracle savepoint rollbackoracle rolling back transactionsoracle get running queriesoracle user last connection dateoracle list dates without weekendssql oracle take only last resultsoracle function return resultsetoracle trace sessionoracle undotbs usageoracle revokeoracle sql all days except weekendsoracle rolling backoracle last connexionoracle get current schemaoracle transaction commit rollback exampleoracle undo usageoracle undo usage by sessionoracle transaction rollback not workinghow to check last gather stats on table in oracleoracle rollbackoracle previous yearroll up oracleoracle show errorsoracle current session detailshow to get previous year from sysdate in oracle
queries leading to this page
oracle rollback statushow to check rollback status in oraclehow to check rollback status in oracle