Temp Tablespace and UNDO Tablespace management

Check UNDO tablespace usage SELECT file_name, tablespace_name, bytes/1024/1024 UNDO_SIZE_MB, SUM (bytes/1024/1024) OVER() TOTAL_UNDO_SIZE_MB FROM dba_data_files d WHERE EXISTS (SELECT 1 FROM v$parameter p WHERE LOWER (p.name)=’undo_tablespace’ AND p.value=d.tablespace_name); Add datafile to undo... Read more »