oracle怎么测试包,Oracle 11g内置的IO测试包

Prerequisites for I/O Calibration

Before running I/O calibration, ensure that the following requirements are met:

The user must be granted the SYSDBA privilege

timed_statistics must be set to TRUE

Asynchronous I/O must be enabled

When using file systems, asynchronous I/O can be enabled by setting the FILESYSTEMIO_OPTIONS initialization parameter to SETALL.

Ensure that asynchronous I/O is enabled for data files by running the following query: COL NAME FORMAT A50

SELECT NAME,ASYNCH_IO FROM V$DATAFILE F,V$IOSTAT_FILE I

WHERE F.FILE#=I.FILE_NO

AND FILETYPE_NAME='Data File';

To run I/O calibration and assess the I/O capability of the storage subsystem used by Oracle Database, use the DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure:

SET SERVEROUTPUT ON

DECLARE

lat INTEGER;

iops INTEGER;

mbps INTEGER;

BEGIN

-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (, , iops, mbps, lat);

DBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 10, iops, mbps, lat);

DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);

DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);

dbms_output.put_line('max_mbps = ' || mbps);

end;

/

At any time during the I/O calibration process, you can query the calibration status in theview. After I/O calibration is successfully completed, you can view the results in thetable.

V$IO_CALIBRATION_STATUSDBA_RSRC_IO_CALIBRATE