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 vote248 views1 answer
How to subquey to do not load in live database in
SQL
0 vote238 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote266 views1 answer
Convert rows into columns in oracle
SQL
0 vote210 views1 answer
Oracle running queries sql
SQL
0 vote191 views1 answer
Mql5 list all available symbols
SQL
0 vote261 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote168 views1 answer
Oracle boolean to varchar
SQL
0 vote226 views1 answer
Sql requete number pair
SQL
0 vote195 views1 answer
Sql datediff db2
SQL
0 vote201 views1 answer
Jenkins SQLCMD run
SQL