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