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 vote110 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
3 votes118 views2 answers
How to View column names of a table in SQL
SQL
1 vote62 views1 answer
Foreign key in oracle sql developer
SQL
7 votes105 views1 answer
Safe update mysql
SQL
0 vote106 views1 answer
Sql server remove enter from string
SQL
0 vote66 views3 answers
Mysql calculate age from date of birth
SQL
1 vote97 views1 answer
Too many connections mysql
SQL
4 votes93 views3 answers
Count with where
SQL
0 vote116 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote111 views1 answer
Mysql f# examples
SQL