A.1.1 V$EXA_FILE

The V$EXA_FILE view contains information about Oracle Database files stored in Exascale.

Table A-1 V$EXA_FILE Columns and Descriptions

Column	Datatype	Description
FULL_PATH	VARCHAR2(1024)	Full file path, including the vault name and file path inside the vault.
VAULT_NAME	VARCHAR2(256)	Name of the Exascale vault containing the file.
FILE_NAME	VARCHAR2(1024)	File path inside the vault.
REDUNDANCY	VARCHAR2(20)	File redundancy setting. Possible values are: high: Indicates three mirrored copies of the file data.
CONTENT_TYPE	VARCHAR2(20)	File content type. Possible values are: DATA: Principally associated with user data. RECO: Primarily for data used in backup and recovery operations.
MEDIA_TYPE	VARCHAR2(20)	Storage media type used by the file. The supported media types are: HC: Identifies high capacity storage, using hard disk drives (HDDs) on high-performance Exadata storage servers. EF: Identifies extreme flash storage, using low-latency, high-throughput flash devices. XT: Identifies extended storage, using HDDs on Exadata storage servers optimized for cost-effective online storage of less frequently accessed data.
CREATE_TIME	DATE	File creation time.
FILE_TYPE	VARCHAR2(30)	Oracle Database file type.
SIZE_IN_BYTES	NUMBER	File size in bytes.
SPACE_USED	NUMBER	Storage space used by the file.
USED_BY	VARCHAR2(64)	Identifies the Oracle Grid Infrastructure cluster or Oracle Database associated with the file.
CON_ID	NUMBER	Oracle Database container ID.