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

3 votes191 views1 answer
Get current month last date in sql server
SQL
1 vote210 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote190 views2 answers
Null value in column violates not-null constraint
SQL
0 vote139 views1 answer
Kannst du deine finger trainieren
SQL
0 vote178 views1 answer
Shrink database file in sql server
SQL
0 vote191 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote199 views1 answer
Disable database droping sql
SQL
0 vote177 views1 answer
Psql select * from table
SQL
0 vote200 views2 answers
Postgresql gset
SQL
0 vote195 views1 answer
Sql server for loop
SQL