SQL> select FILE_NAME, bytes/1024/1024/1024 from dba_temp_files;

FILE_NAME BYTES/1024/1024/1024
-------------------------------------------------- --------------------
+DATA/DBPROD/TEMPFILE/temp.260.867935783 29.296875
+DATA/DBPROD/TEMPFILE/temp.257.857144729 31.9990234

SQL> SELECT * FROM dba_temp_free_space;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP 6.5816E+10 819986432 6.5774E+10


SQL> ALTER DATABASE TEMPFILE '+DATA/DBPROD/TEMPFILE/temp.260.867935783' resize 2g;

Database altered.

SQL> ALTER DATABASE TEMPFILE '+DATA/DBPROD/TEMPFILE/temp.257.857144729' resize 2g;

Database altered.

SQL> select FILE_NAME, bytes/1024/1024/1024 from dba_temp_files;

FILE_NAME BYTES/1024/1024/1024
-------------------------------------------------- --------------------
+DATA/DBPROD/TEMPFILE/temp.260.867935783 2
+DATA/DBPROD/TEMPFILE/temp.257.857144729 2

SQL> SELECT * FROM dba_temp_free_space;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP 4294967296 44040192 4250927104





Komentáře