Oracle undo usage per session

-- UNDOTBS usage per User:
SELECT u.TABLESPACE_NAME          AS TABLESPACE,
       s.USERNAME,
       u.STATUS,
       sum(u.BYTES) / 1024 / 1024 AS SUM_IN_MB,
       count(u.SEGMENT_NAME)      AS SEG_CNTS
FROM DBA_UNDO_EXTENTS u, V$TRANSACTION T, V$SESSION s
WHERE T.ADDR = s.TADDR
GROUP BY u.TABLESPACE_NAME, s.USERNAME, u.STATUS
ORDER BY 1, 2, 3;

Similar codes

1 vote134 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote173 views1 answer
Drop a view in sqlite
SQL
0 vote145 views2 answers
Php convert dbf to mysql
SQL
0 vote142 views1 answer
Psql check table fields
SQL
0 vote118 views1 answer
Clone table structure mysql
SQL
0 vote120 views1 answer
Mysql case when on date
SQL
0 vote145 views2 answers
Transaction php
SQL
0 vote131 views1 answer
Oracle enable chain
SQL
2 votes175 views1 answer
How to create sql database
SQL
0 vote140 views1 answer
Alter table change default
SQL