Database 11g

Thursday, April 14, 2016

How to Check Temp Tablespace Free Size in Oracle Database


SQL> SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
COL TABLESPACE_SIZE FOR 999,999,999,999
COL ALLOCATED_SPACE FOR 999,999,999,999
COL FREE_SPACE FOR 999,999,999,999
SELECT *  FROM   dba_temp_free_space;

Press Return to Continue

TABLESPACE       TABLESPACE_SIZE         ALLOCATED_SPACE             FREE_SPACE
---------- ---------------- ---------------- --------------------------------------------------------------------
TEMP                        39,460,012,032               39,269,171,200                39,457,914,880


Happy  Learning ....















No comments:

Post a Comment