Purge undo tablespace usage

-- 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 vote150 views0 answer
SQL
0 vote171 views2 answers
Starting mysql service from mac
SQL
0 vote163 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
2 votes183 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote160 views1 answer
Oracle select invalid views
SQL
1 vote175 views2 answers
Reset mysqli fetch_arra
SQL
12 votes217 views10 answers
Google
SQL
22 votes154 views2 answers
Mysql show all tables
SQL
8 votes185 views2 answers
Grant all privileges database postgres to user
SQL
1 vote277 views1 answer
Mysql monthname
SQL