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 [...]