Friday 10 January 2014

How To See Free Space of Each Tablespace?

SQL> conn scott/tiger
Connected.
SQL> SELECT TABLESPACE_NAME, FILE_ID, BYTES  FROM USER_FREE_SPACE  WHERE TABLESPACE_NAME IN ('USERS', 'ABDULWASIQ');

TABLESPACE_NAME              FILE_ID      BYTES
------------------------- ---------- ----------
ABDULWASIQ                         7    9371648
USERS                              5  208666624
USERS                              4    3866624

SQL>

No comments:

Post a Comment