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 tablespace ALTER TABLESPACE UNDOTBS1 ADD DATAFILE E:\APP\ANKUSH\ORADATA\MYDB\UNDOTBS02.DBF’ size 10M; Query to see Current Temp Datafiles State set pages 999 set lines 400 col …

Temp Tablespace and UNDO Tablespace management Read More »