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:
|
CONTENT_TYPE | VARCHAR2(20) |
File content type. Possible values are:
|
MEDIA_TYPE | VARCHAR2(20) |
Storage media type used by the file. The supported media types are:
|
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. |
Parent topic: Oracle Database Dictionary Views