UNDO management
-- UNDO tablespace space
select tablespace_name tablespace,
status,
sum(bytes)/1024/1024 MB,
count(*) counts
from dba_undo_extents
group by tablespace_name, status
order by 1,2;
-- UNDO Retention
ALTER SYSTEM SET UNDO_RETENTION = 1800