DBA_DATA_FILES

Information about database data files

Columns
   ___________________________
 
   FILE_NAME
      Name of the database data file
   FILE_ID
      ID of the database data file
   TABLESPACE_NAME
      Name of the tablespace to which the file belongs
   BYTES
      Size of the file in bytes
   BLOCKS
      Size of the file in ORACLE blocks
   STATUS
      File status: "INVALID" or "AVAILABLE"
   RELATIVE_FNO
      Tablespace-relative file number
   AUTOEXTENSIBLE
      Autoextensible indicator: "YES" or "NO"
   MAXBYTES
      Maximum size of the file in bytes
   MAXBLOCKS
      Maximum size of the file in ORACLE blocks
   INCREMENT_BY
      Default increment for autoextension
   USER_BYTES
      Size of the useful portion of file in bytes
   USER_BLOCKS
      Size of the useful portion of file in ORACLE blocks

Example SQL

-- List the Files in each Tablespace:

Select
RPAD(tablespace_name,18)||' '||RTRIM(file_name) Tablespace
From
dba_data_files
Order By tablespace_name;

Related:

SQL Script - Tablespace Free Space


© Copyright SS64.com 1999-2014
Some rights reserved