Hi All,
I want to release some space from the undo tablespace. ie from the unexpired and expired segments. how can we do it safely. We have a database with 700G undo, often undo gets filled up due to high number of transactions.
SQL> select tablespace_name, status, sum(blocks) * 8192/1024/1024/1024 GB from dba_undo_extents group by tablespace_name, status;
TABLESPACE_NAME STATUS GB
------------------------------ --------- ----------
UNDOTBS1 UNEXPIRED 85.8811389
UNDOTBS2 UNEXPIRED 22.5623955
UNDOTBS1 EXPIRED 35.3218981
UNDOTBS2 EXPIRED 1.28218592
UNDOTBS2 ACTIVE .783908906
UNDOTBS1 ACTIVE .902959142
6 rows selected.
DB version is 11.2.0.3