Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_san_details view |
block_size | NUMBER | Block size of the file (in bytes) |
blocks | NUMBER | Number of blocks in the file |
bytes | NUMBER | Number of bytes in the file |
db_name | STRING | Unique database name of the database client instance |
disk_group_id | NUMBER | Primary key from the aps_v_asm_diskgroup view |
file_creation_date | DATE | Date and time file was created |
file_incarnation | NUMBER | Incarnation number for the file (composite primary key) |
file_modified_date | DATE | Date and time file was modified |
file_name | STRING | Alias name on the combination of file_number and file_incarnation |
file_number | NUMBER | Number of the file within the disk group (composite primary key) |
file_type_tag | STRING | Type specific information about the file |
last_updated | DATE | Date and time last updated |
redundancy | STRING | Redundancy of the file with the following possible values: UNPROT MIRROR HIGH |
redundancy_lowered | STRING | Indicates whether a file has lower redundancy than what was expected (Y) or not (N). Redundancy is said to have been lowered for a file when one or more data extents in that file are not mirrored at the level specified by the administrator. In case of unprotected files, data extents could be missing altogether. Another possible value for this column is (U), which means that it is unknown |
space | NUMBER | Number of bytes allocated to the file |
striped | STRING | Indicates how the file is striped with the following possible values: FINE COARSE |
type | STRING | Type of the file. Possible values are as follows: CONTROLFILE DATAFILE ONLINELOG ARCHIVELOG TEMPFILE BACKUPSET XTRANSPORT PARAMETERFILE DATAGUARDCONFIG FLASHBACK CHANGETRACKING DUMPSET AUTOBACKUP |