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

1 vote176 views1 answer
How to select random rows from table
SQL
0 vote175 views1 answer
Mysql does collate nopad recognize space
SQL
6 votes179 views2 answers
Postgresql restore from dump
SQL
2 votes187 views4 answers
Sql query interview questions
SQL
4 votes301 views2 answers
Sql select except null
SQL
2 votes165 views1 answer
How to delete columns in sql
SQL
0 vote171 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote190 views1 answer
Increase existing date in sql
SQL
1 vote191 views1 answer
Create table variable in sql stored procedure
SQL
0 vote180 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL