Storage Viewer for Capacity Database Views > aps_v_asm_dbclient_diskio_log
  
Version 10.0.01
aps_v_asm_dbclient_diskio_log
The aps_v_asm_dbclient_diskio_log has disk IO performance data for each DB client.
Table 4.48 aps_v_asm_dbclient_diskio_log
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
bytes_read
NUMBER
Total number of bytes read from the disk
bytes_written
NUMBER
Total number of bytes written to the disk
cold_bytes_read
NUMBER
Number of bytes read from the cold region on disk
cold_bytes_written
NUMBER
Number of bytes written to the cold region on disk
cold_reads
NUMBER
Number of reads from the cold region on disk
cold_writes
NUMBER
Number of writes to the cold region on disk
db_instance_name
STRING
Identifier for the database instance client
disk_id
NUMBER
Primary key from the view
hot_bytes_read
NUMBER
Number of bytes read from the hot region on disk
hot_bytes_written
NUMBER
Number of bytes written to the hot region on disk
hot_reads
NUMBER
Number of reads from the hot region on disk
hot_writes
NUMBER
Number of writes to the hot region on disk
log_date
DATE
Date and time the log record was created
read_errs
NUMBER
Total number of failed I/O read requests for the disk
read_time
NUMBER
Total I/O time (in seconds) for read requests for the disk if the TIMED_
STATISTICS initialization parameter is set to true (0 if set to false)
reads
NUMBER
Total number of I/O read requests for the disk
write_errs
NUMBER
Total number of failed I/O write requests for the disk
write_time
NUMBER
Total I/O time (in seconds) for write requests for the disk if the TIMED_
STATISTICS initialization parameter is set to true (0 if set to false)
writes
NUMBER
Total number of I/O write requests for the disk