[Home] [Help] [Dependency Information]
Object Name: | DBA_DATA_FILES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Information about database data files
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILE_NAME | VARCHAR2 | (513) | Name of the database data file | |
FILE_ID | NUMBER | ID of the database data file | ||
TABLESPACE_NAME | VARCHAR2 | (30) | Name of the tablespace to which the file belongs | |
BYTES | NUMBER | Size of the file in bytes | ||
BLOCKS | NUMBER | Size of the file in ORACLE blocks | ||
STATUS | VARCHAR2 | (9) | File status: "INVALID" or "AVAILABLE" | |
RELATIVE_FNO | NUMBER | Tablespace-relative file number | ||
AUTOEXTENSIBLE | VARCHAR2 | (3) | Autoextensible indicator: "YES" or "NO" | |
MAXBYTES | NUMBER | Maximum autoextensible file size in bytes | ||
MAXBLOCKS | NUMBER | Maximum autoextensible file size in blocks | ||
INCREMENT_BY | NUMBER | Default increment for autoextension | ||
USER_BYTES | NUMBER | Size of the useful portion of file in bytes | ||
USER_BLOCKS | NUMBER | Size of the useful portion of file in ORACLE blocks | ||
ONLINE_STATUS | VARCHAR2 | (7) | Online status of the file |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_NAME
, FILE_ID
, TABLESPACE_NAME
, BYTES
, BLOCKS
, STATUS
, RELATIVE_FNO
, AUTOEXTENSIBLE
, MAXBYTES
, MAXBLOCKS
, INCREMENT_BY
, USER_BYTES
, USER_BLOCKS
, ONLINE_STATUS
FROM SYS.DBA_DATA_FILES;
|
|
|