Oracle IO校準特性

[oracle@db01 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 26 15:53:43 2018


Copyright (c) 1982, 2013, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL>  set serveroutput on;
SQL> DECLARE
    lat  INTEGER;
      iops INTEGER;
     mbps INTEGER;
   BEGIN
   -- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (disk_count,max_latency , iops, mbps, lat);
      DBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 15, iops, mbps, lat);
  
      DBMS_OUTPUT.PUT_LINE   2    3    4    5    6    7    8    9  ('max_iops = ' || iops);
     DBMS_OUTPUT.PUT_LINE ('latency  = ' || lat);
     dbms_output.put_line('max_mbps = ' || mbps);
  end; 10   11   12  
 13  /
max_iops = 140
latency  = 13
max_mbps = 62


PL/SQL procedure successfully completed.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2153396/，如需轉載，請註明出處，否則將追究法律責任。