DBA_RSRC_IO_CALIBRATE

DBA_RSRC_IO_CALIBRATE displays I/O calibration results for the latest calibration run.


Column Datatype NULL Description

START_TIME

TIMESTAMP(6)

 

Start time of the most recent I/O calibration

END_TIME

TIMESTAMP(6)

 

End time of the most recent I/O calibration

MAX_IOPS

NUMBER

 

Maximum number of data block read requests that can be sustained per second

MAX_MBPS

NUMBER

 

Maximum megabytes per second of maximum-sized read requests that can be sustained

MAX_PMBPS

NUMBER

 

Maximum megabytes per second of large I/O requests that can be sustained by a single process

LATENCY

NUMBER

 

Latency for data block read requests

NUM_PHYSICAL_DISKS

NUMBER

 

Number of physical disks in the storage subsystem (as specified by the user)