v 24transaction 12c

1-- Active transactions (generating UNDO)
2SELECT s.SID, s.SERIAL#, s.CLIENT_INFO, t.ADDR, sum(t.USED_UBLK)
3FROM V$TRANSACTION t,
4     V$SESSION s
5WHERE t.ADDR = s.TADDR
6GROUP BY s.SID, s.SERIAL#, s.CLIENT_INFO, t.ADDR;