Database 11g

Monday, January 1, 2018

How to Check Particular Tablespace Size with Datafiles in Oracle




SQL> select tablespace_name,file_name,(bytes/1024/1024) from dba_data_files where tablespace_name='USERS'

TABLESPACE                                   FILE_NAME                                   (BYTES/1024/1024)
-------------- -----------------------------------------------------------------------------------------------------------------
USERS                          +DATA/kkprod/datafile/users.267.962995627                 25600
USERS                          +DATA/kkprod/datafile/users.269.963077837                 20480



Happy Learning....

No comments:

Post a Comment