Tuesday, August 19, 2014

How to check UNDO tablespace total and occupied size

select tablespace_name,sum(bytes) total_bytes from dba_data_files where tablespace_name like '%UNDO%' group by tablespace_name;

select tablespace_name,sum(bytes) occupied_bytes from dba_segments where tablespace_name like '%UNDO%' group by tablespace_name;

No comments:

Post a Comment