Answers for "how to check rollback status in oracle"

SQL

0

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;

Posted by: Guest on September-11-2021

Source

Code answers related to "how to check rollback status in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#