Dynamic Performance (V$) Views, 34 of 179

V$DATAFILE

This view contains datafile information from the control file.

See Also:
"V$DATAFILE_HEADER", which displays information from datafile headers.

Column Datatype Description

FILE#

NUMBER

File identification number

STATUS

VARCHAR2

Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF (an offline file from the SYSTEM tablespace)

ENABLED

VARCHAR2(10)

Describes how accessible the file is from SQL:

DISABLED: No SQL access allowed

READ ONLY: No SQL updates allowed

READ WRITE: Full access allowed

UNKNOWN: Should not occur unless the control file is corrupted.

CHECKPOINT_CHANGE#

NUMBER

SCN at last checkpoint

CHECKPOINT_TIME

DATE

Time stamp of the checkpoint#

UNRECOVERABLE _CHANGE#

NUMBER

Last unrecoverable change# made to this datafile. This column is always updated when an unrecoverable operation completes

UNRECOVERABLE_TIME

DATE

Time stamp of the last unrecoverable change

BYTES

NUMBER

Current size in bytes; 0 if inaccessible

CREATE_BYTES

NUMBER

Size when created, in bytes

NAME

VARCHAR2

Name of the file

CREATION_CHANGE#

NUMBER

Change number at which the datafile was created

CREATION_TIME

DATE

Timestamp of the datafile creation

TS#

NUMBER

Tablespace number

RFILE#

NUMBER

Tablespace relative datafile number

LAST_CHANGE#

NUMBER

Last change# made to this datafile. Set to NULL if the datafile is being changed

LAST_TIME

DATE

Timestamp of the last change

OFFLINE_CHANGE#

NUMBER

Offline change# of the last offline range. This column is updated only when the datafile is brought online

ONLINE_CHANGE#

NUMBER

Online change# of the last offline range

ONLINE_TIME

DATE

Online timestamp of the last offline range

BLOCKS

NUMBER

Current datafile size in blocks; 0 if inaccessible

BLOCK_SIZE

NUMBER

Block size of the datafile

NAME

VARCHAR2(512)

Datafile name

PLUGGED_IN

NUMBER

Describes whether the tablespace is plugged in. The value is 1 if the tablespace is plugged in and has not been made read-write, 0 if not.

Column	Datatype	Description
`FILE#`	`NUMBER`	File identification number
`STATUS`	`VARCHAR2`	Type of file (system or user) and its status. Values: `OFFLINE`, `ONLINE`, `SYSTEM`, `RECOVER`, `SYSOFF` (an offline file from the SYSTEM tablespace)
`ENABLED`	`VARCHAR2(10)`	Describes how accessible the file is from SQL: `DISABLED`: No SQL access allowed `READ` `ONLY`: No SQL updates allowed `READ` `WRITE`: Full access allowed `UNKNOWN`: Should not occur unless the control file is corrupted.
`CHECKPOINT_CHANGE#`	`NUMBER`	SCN at last checkpoint
`CHECKPOINT_TIME`	`DATE`	Time stamp of the checkpoint#
`UNRECOVERABLE _CHANGE#`	`NUMBER`	Last unrecoverable change# made to this datafile. This column is always updated when an unrecoverable operation completes
`UNRECOVERABLE_TIME`	`DATE`	Time stamp of the last unrecoverable change
`BYTES`	`NUMBER`	Current size in bytes; 0 if inaccessible
`CREATE_BYTES`	`NUMBER`	Size when created, in bytes
`NAME`	`VARCHAR2`	Name of the file
`CREATION_CHANGE#`	`NUMBER`	Change number at which the datafile was created
`CREATION_TIME`	`DATE`	Timestamp of the datafile creation
`TS#`	`NUMBER`	Tablespace number
`RFILE#`	`NUMBER`	Tablespace relative datafile number
`LAST_CHANGE#`	`NUMBER`	Last change# made to this datafile. Set to NULL if the datafile is being changed
`LAST_TIME`	`DATE`	Timestamp of the last change
`OFFLINE_CHANGE#`	`NUMBER`	Offline change# of the last offline range. This column is updated only when the datafile is brought online
`ONLINE_CHANGE#`	`NUMBER`	Online change# of the last offline range
`ONLINE_TIME`	`DATE`	Online timestamp of the last offline range
`BLOCKS`	`NUMBER`	Current datafile size in blocks; 0 if inaccessible
`BLOCK_SIZE`	`NUMBER`	Block size of the datafile
`NAME`	`VARCHAR2(512)`	Datafile name
`PLUGGED_IN`	`NUMBER`	Describes whether the tablespace is plugged in. The value is 1 if the tablespace is plugged in and has not been made read-write, 0 if not.