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 vote277 views1 answer
Oracle current date minus 1 day
SQL
10 votes256 views4 answers
Mysql one week ago
SQL
0 vote217 views1 answer
The fetch keyword oracle
SQL
0 vote193 views1 answer
Pl/sql loop example
SQL
7 votes202 views1 answer
Buy forge mods server hosting
SQL
1 vote247 views1 answer
Oracle extract minute from date
SQL
0 vote195 views1 answer
Sql find all different values in column
SQL
1 vote153 views1 answer
Oracle character set
SQL
2 votes177 views2 answers
How to create an empty table from an existing table
SQL
0 vote160 views1 answer
Oracle function select into
SQL