V$ASM_DISK_IOSTAT
displays information about disk I/O statistics for each Oracle Automatic Storage Management (Oracle ASM) client. If this view is queried from the database instance, only the rows for that instance are shown.
Column | Datatype | Description |
---|---|---|
|
|
Identifier for the DB/ADVM instance client |
|
|
Unique database name ( |
|
|
Name of the cluster |
|
|
Number of the disk group containing the disk |
|
|
Number assigned to the disk within its disk group |
|
|
Name of the failure group to which the disk belongs |
|
|
Total number of I/O read requests for the disk |
|
|
Total number of I/O write requests for the disk |
|
|
Total number of failed I/O read requests for the disk |
|
|
Total number of failed I/O write requests for the disk |
|
|
Number of read I/Os that are timed out |
|
|
Number of write I/Os that are timed out |
|
|
Total I/O time (in seconds) for read requests for the disk if the |
|
|
Total I/O time (in seconds) for write requests for the disk if the |
|
|
Total number of bytes read from the disk |
|
|
Total number of bytes written from the disk |
|
|
Number of reads from the hot region on disk |
|
|
Number of writes to the hot region on disk |
|
|
Number of bytes read from the hot region on disk |
|
|
Number of bytes written to the hot region on disk |
|
|
Number of reads from the cold region on disk |
|
|
Number of writes to the cold region on disk |
|
|
Number of bytes read from the cold region on disk |
|
|
Number of bytes written to the cold region on disk |
|
|
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