Temp Tablespace Usage

Oracle Temp Tablespace usage

Check for Temp tablespace usage

set lin 200;

col file_name for a75;

col autoextensible for a15;

select file_name,tablespace_name,sum(bytes)/1024/1024 as FILE_SIZE,sum(maxbytes)/1024/1024 as MAX_SIZE,autoextensible from dba_temp_files

where tablespace_name ='TEMP' group by file_name,tablespace_name,autoextensible order by file_name;

Add a temp file to temp tablespace:

ALTER TABLESPACE TEMP add tempfile '<tempfile_name.dbf>' SIZE 2G REUSE AUTOEXTEND OFF;

Best Wishes!!