Answers for "v$transaction oracle"

SQL
5

oracle v$TRANSACTION

-- Active transactions (generating UNDO)
SELECT s.SID, s.SERIAL#, s.CLIENT_INFO, t.ADDR, sum(t.USED_UBLK)
FROM V$TRANSACTION t,
     V$SESSION s
WHERE t.ADDR = s.TADDR
GROUP BY s.SID, s.SERIAL#, s.CLIENT_INFO, t.ADDR;
Posted by: Guest on September-11-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language