Category Archives: Temporary Tablespace Maintenance

—- 1.  Check the Existing Temp Tablespace Size and Data file List
col FILE_NAME       format a50
col TABLESPACE_NAME format a15
col BYTES           format 999,999,999,999
col MAXBYTES        format 999,999,999,999
set linesize 1000
SQL> select FILE_NAME,TABLESPACE_NAME, BYTES, MAXBYTES from  dba_temp_files;
FILE_NAME                                          TABLESPACE_NAME            BYTES         MAXBYTES
————————————————– ————— —————- —————-
/u01/app/oracle/oradata/ORATEST/temp01.dbf         TEMP                 601,882,624   34,359,721,984
SQL>
—- 2. Reduce the Temp Tablespace Size
alter database tempfile ‘/u01/app/oracle/oradata/ORATEST/temp01.dbf’ resize 50M;
SQL> alter database tempfile [...]