Oracle Views to get Info About Tablespaces and Datafiles | Oracle Database

Oracle Views to get Information regarding Oracle Tablespaces and Datafiles

Oracle has provided many Data dictionary views to get information about tablespaces and datafiles.  Some of them are:

To view information about Tablespaces in a database give the following query

SQL> select * from dba_tablespaces;

SQL> select * from v$tablespace;

To view information about Datafiles

SQL> select * from dba_data_files;

SQL> select * from v$datafile;

To view information about Tempfiles

SQL> select * from dba_temp_files;

SQL> select * from v$tempfile;

To view information about free space in datafiles

SQL> select * from dba_free_space;

To view information about free space in tempfiles

SQL> select * from V$TEMP_SPACE_HEADER;