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