7.67 V$ASM_FILE
In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_FILE
displays one row for each file in each disk group mounted by the Oracle ASM instance.
For example, if there are three disk groups and five files in each, fifteen rows are displayed (unless the query is qualified with a WHERE
clause).
Column | Datatype | Description |
---|---|---|
|
|
Number of the disk group containing the file (composite primary key) |
|
|
Number of the file within the disk group (composite primary key) |
|
|
A 32-bit number consisting of a disk group number in the high-order 8 bits and a file number in the low-order 24 bits (for efficient access to the view) |
|
|
Incarnation number for the file (composite primary key) |
|
|
Block size of the file (in bytes) |
|
|
Number of blocks in the file |
|
|
Number of bytes in the file |
|
|
Number of bytes allocated to the file |
|
|
Type of the file. Possible values are as follows:
|
|
|
Redundancy of the file:
|
|
|
Indicates how the file is striped:
|
|
|
Date on which the file was created |
|
|
Date of the last open/close for writing, rounded back to the nearest hour |
|
|
Indicates whether a file has lower redundancy than what was expected ( This column is deprecated, and it always displays a value of |
|
|
Access permissions of the file, in order of user, group, and other |
|
|
User number |
|
|
Incarnation number of the user |
|
|
User group number |
|
|
Incarnation number of the user group |
|
|
Region used for allocating primary extents:
|
|
|
Region for allocating mirrored extents:
|
|
|
Number of reads from the hot region for the file |
|
|
Number of writes to the hot region for the file |
|
|
Number of bytes read from the hot region for the file |
|
|
Number of bytes written to the hot region for the file |
|
|
Number of reads from the cold region for the file |
|
|
Number of writes to the cold region for the file |
|
|
Number of bytes read from the cold region for the file |
|
|
Number of bytes written to the cold region for the file |
|
|
Shows the number of the associated file group |
|
|
The incarnation number for the file group the file belongs to in a flex redundancy disk group |
|
|
This column has the value |
|
|
For internal use only. |
|
|
For internal use only. |
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
See Also:
Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information