Purge undo tablespace oracle 11g

-- UNDO tablespace current usage / available space
SELECT a.TABLESPACE_NAME, SIZEMB, USAGEMB, (SIZEMB - USAGEMB) AS FREEMB
FROM (SELECT round(sum(BYTES) / 1e6) AS SIZEMB, b.TABLESPACE_NAME
      FROM DBA_DATA_FILES a, DBA_TABLESPACES b
      WHERE a.TABLESPACE_NAME = b.TABLESPACE_NAME AND b.CONTENTS LIKE 'UNDO'
      GROUP BY b.TABLESPACE_NAME) a,
     (SELECT c.TABLESPACE_NAME, sum(BYTES) / 1e6 AS USAGEMB
      FROM DBA_UNDO_EXTENTS c
      WHERE STATUS <> 'EXPIRED'
      GROUP BY c.TABLESPACE_NAME) b
WHERE a.TABLESPACE_NAME = b.TABLESPACE_NAME;

Source: smarttechways.com

Similar codes

0 vote145 views1 answer
Sql server size of every table in a db
SQL
1 vote250 views1 answer
Postgres set column based on another column
SQL
0 vote146 views1 answer
Sql put two columns into one
SQL
0 vote146 views2 answers
Generate sql trigger through ef migration
SQL
2 votes132 views1 answer
Sql like variable
SQL
0 vote148 views1 answer
Oracle list partitions
SQL
0 vote141 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
4 votes188 views1 answer
Postgresql list sequences
SQL
0 vote147 views1 answer
Oracle c# multiple update sql
SQL
0 vote150 views1 answer
Sql query to get contact form 7 fields
SQL