Search notes:

DBMS_RESOURCE_MANAGER.CALIBRATE_IO

dbms_resource_manager.calibrate_io calibrates I/O capabilities by gathering statistics on I/O operations. This is typically required only after hardware has changed.
declare
   max_io_per_second pls_integer;
   max_mb_per_second pls_integer;
   actual_latency    pls_integer;

begin

   dbms_resource_manager.calibrate_io(
   -- num_physical_disks    =>   use default
   -- max_latency           =>   use default
      max_iops              =>   max_io_per_second,
      max_mbps              =>   max_mb_per_second,
      actual_latency        =>   actual_latency
   );


   dbms_output.put_line('Max io/s: ' || to_char(max_io_per_second, '9999990'      ));
   dbms_output.put_line('Max MB/s: ' || to_char(max_mb_per_second, '9999990'      ));
   dbms_output.put_line('Act. lat: ' || to_char(actual_latency   ,    '9990.99999'));

end;
/

select * from v$io_calibration_status;
select * from dba_rsrc_io_calibrate;

See also

dbms_resource_manager

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758207381, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/resource_manager/api/calibrate_io/index(63): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78