ivestigating undo-tablespace in EBS R12


SELECT version FROM v$timezone_file;

select count(status) from dba_undo_extents where status = 'ACTIVE';
select count(status) from dba_undo_extents where status = 'UNEXPIRED';

select (sum(bytes)/(1024*1024)) "SIZE in MB",tablespace_name from dba_free_space group by tablespace_name;