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

0 vote330 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote321 views1 answer
Sql delete row from table where id
SQL
0 vote350 views1 answer
Csv to sqlite python
SQL
1 vote330 views2 answers
Limit sqlserver
SQL
1 vote367 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote347 views1 answer
Update having mysql
SQL
1 vote335 views1 answer
Where to locate set password for mysql
SQL
0 vote333 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote356 views1 answer
Oracle sql alter view add column
SQL
0 vote345 views1 answer
Mysql grant grant option
SQL