v 24transaction 19c

Solutions on MaxInterview for v 24transaction 19c by the best coders in the world

showing results for - "v 24transaction 19c"
Nicolò
24 Jun 2019
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;