Oracle undo tablespace schema

-- UNDO tablespace usage per user / session
SELECT s.SID, s.USERNAME, round(sum(ss.VALUE) / 1e6, 2) AS UNDO_SIZE_MB,
       sql.ELAPSED_TIME, sql.SQL_TEXT
FROM V$SESSTAT ss JOIN V$SESSION s ON s.SID = ss.SID
     JOIN V$STATNAME STAT ON STAT.STATISTIC# = ss.STATISTIC#
     LEFT JOIN V$SQLAREA sql 
     	ON s.SQL_ADDRESS = sql.ADDRESS AND s.SQL_HASH_VALUE = sql.HASH_VALUE
WHERE STAT.NAME = 'undo change vector size' AND s.TYPE <> 'BACKGROUND' 
  AND s.USERNAME IS NOT NULL AND ss.VALUE >= 0.01 * 1e6
GROUP BY s.SID, s.USERNAME, sql.ELAPSED_TIME, sql.SQL_TEXT
ORDER BY s.USERNAME, round(sum(ss.VALUE) / 1e6, 2);

Source: dba.stackexchange.com

Similar codes

6 votes89 views3 answers
Can you update NULL in sql
SQL
7 votes106 views1 answer
Mysql remote connection command line
SQL
9 votes104 views3 answers
Show table columns mysql command line
SQL
0 vote101 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote112 views2 answers
Demmarrer un service mysql teminal cmd
SQL
1 vote108 views1 answer
Sql server cast date dd/mm/yyyy
SQL
1 vote105 views1 answer
Mysql history command
SQL
10 votes108 views6 answers
Between sql
SQL
0 vote162 views1 answer
Sql delete row from table where id
SQL
1 vote143 views1 answer
Wordpress change url phpmyadmin
SQL