tablespace info

[230173]

How can i get all the tablespace info.
Free space, Size,Max size,... in bytes.
And also the size of al the datafiles in that tablespace(with size,location, max size,.... in bytes)
Just an overview of the tablespaces.

 

[230173]

in SQL.

 

[kindus]

You can get all these information from the following dictionary tables
1) dba_tablespaces
2) dba_free_space
3) dba_data_files

Those columns are self explanatory, also you may refer Oracle Reference manual for column details.

Please reply if you find difficulty finding your info.

Hope it helps!

 

[THoey]

Or you can log into the database using Oracle DBA Studio and find all this info... Terry M. Hoey