dba_data_files

Dba_data_files

Dba_data_files is a default view in Oracle database. This contains information about the data files in the database.

Some important columns in this view are:

File_name:

Contains the path of the data file

File_id:

Contains the unique id for each file to identify the files. By using this id we can able to find the files.

Tablespace_name:

Contains the tablespace name which uses the data file to store data.

Bytes:

Contains the size of the data file in bytes.

Online_Status:

Contains the status of the file like offline, online.

Auto extensible:

Contains the information about the auto extensible is set on or off for the file

Incremented By:

Contains the information about if the file got filled by which size it needs to get growing based upon the Auto extensible parameter.

below query, gives the information about files and size of the files in GB.

       Select tablespace_name , file_name, bytes/1024/1024/1024 from dba_data_files;

below query, gives the information about the size of tablespaces.

       Select tablespace_name, sum(bytes)/1024/0124/1024 from dba_data_files group by tablespace_name;