DBA_FREE_SPACE View

posted Feb 3, 2012, 6:53 PM by Sachchida Ojha
You can easily compute the amount of free space in each tablespace using DBA_FREE_SPACE views.

SQL> desc dba_free_space;
 Name                       Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLESPACE_NAME                    VARCHAR2(30)
 FILE_ID                        NUMBER
 BLOCK_ID                        NUMBER
 BYTES                            NUMBER
 BLOCKS                         NUMBER
 RELATIVE_FNO                        NUMBER

SQL>  select tablespace_name, sum(bytes) from dba_free_space group by tablespace_name;

TABLESPACE_NAME            SUM(BYTES)
------------------------------ ----------
SYSAUX                 36700160
UNDOTBS1             28770304
USERS                   851968
SYSTEM                  5308416
EXAMPLE              22609920

SQL>

Click here for the Best Buy Free Shipping Offers

Comments