eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_RSRC_IO_CALIBRATE

Object Details

Object Name:	DBA_RSRC_IO_CALIBRATE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Results of the most recent I/O calibration

[View Source]

Columns

Name	Datatype	Length	Comments
START_TIME	TIMESTAMP(6)	(11)	start time of the most recent I/O calibration
END_TIME	TIMESTAMP(6)	(11)	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 large I/O 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 user)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT START_TIME
,      END_TIME
,      MAX_IOPS
,      MAX_MBPS
,      MAX_PMBPS
,      LATENCY
,      NUM_PHYSICAL_DISKS
FROM SYS.DBA_RSRC_IO_CALIBRATE;

Dependencies

[top of page]

SYS.DBA_RSRC_IO_CALIBRATE references the following:

SYS: RESOURCE_IO_CALIBRATE$

SYS.DBA_RSRC_IO_CALIBRATE is referenced by following:

PUBLIC: DBA_RSRC_IO_CALIBRATE