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 vote343 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote331 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote301 views1 answer
Add plugins to mysql workbench
SQL
24 votes338 views5 answers
Import dump mysql
SQL
0 vote276 views1 answer
Java spring boot connect to sql server
SQL
0 vote393 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote316 views1 answer
Mysql drop vs delete
SQL
0 vote332 views1 answer
View to table sql
SQL
0 vote271 views2 answers
Postgresql could not start server mac
SQL
5 votes328 views2 answers
Postgres update with if condition query
SQL