Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$ASM_DISK_IOSTAT

V$ASM_DISK_IOSTAT displays information about disk I/O statistics for each ASM client. If this view is queried from the database instance, only the rows for that instance are shown.

Column Datatype Description
INSTNAME VARCHAR2(64) Identifier for the DB/AVD instance client
DBNAME VARCHAR2(8) Unique database name (DB_UNIQUE_NAME)
GROUP_NUMBER NUMBER Number of the disk group containing the disk
DISK_NUMBER NUMBER Number assigned to the disk within its disk group
FAILGROUP VARCHAR2(30) Name of the failure group to which the disk belongs
READS NUMBER Total number of I/O read requests for the disk
WRITES NUMBER Total number of I/O write requests for the disk
READ_ERRS NUMBER Total number of failed I/O read requests for the disk
WRITE_ERRS NUMBER Total number of failed I/O write requests for the disk
READ_TIME NUMBER Total I/O time (in hundreths of a second) for read requests for the disk if the TIMED_STATISTICS initialization parameter is set to TRUE (0 if set to FALSE).
WRITE_TIME NUMBER Total I/O time (in hundreths of a second) for write requests for the disk if the TIMED_STATISTICS initialization parameter is set to TRUE (0 if set to FALSE)
BYTES_READ NUMBER Total number of bytes read from the disk
BYTES_WRITTEN NUMBER Total number of bytes written from the disk