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 vote288 views1 answer
Formatting code with SQL Developer
SQL
0 vote317 views1 answer
Joomla execute raw sql
SQL
0 vote237 views2 answers
Delete the last item in a table sql
SQL
0 vote275 views1 answer
Many rows to 1 string mysql
SQL
0 vote279 views1 answer
Join in update query in mysql
SQL
0 vote324 views2 answers
Postgres isnull
SQL
0 vote255 views1 answer
Postgres create database if not exists
SQL
0 vote323 views1 answer
Get total and distict row diff in sql
SQL
0 vote283 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote309 views1 answer
Oracle list datafiles
SQL