{"id":416,"date":"2017-04-04T13:16:59","date_gmt":"2017-04-04T11:16:59","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=416"},"modified":"2017-04-04T13:16:59","modified_gmt":"2017-04-04T11:16:59","slug":"oracle-io-calibrate","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=416","title":{"rendered":"Oracle „IO Calibrate“"},"content":{"rendered":"

Das\u00a0DBMS_RESOURCE_MANAGER Paket beinhaltet die „CALIBRATE_IO“-Prozedur mit der belastbare I\/O-Statistiken zu den angebundenen Filesystemen ermittelt werden k\u00f6nnen.<\/p>\n

Beispiel:<\/p>\n

SET SERVEROUTPUT ON
\n<\/em>DECLARE
\n<\/em>\u00a0 l_max_iops\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PLS_INTEGER;
\n<\/em>\u00a0 l_max_mbps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PLS_INTEGER;
\n<\/em>\u00a0 l_actual_latency\u00a0 PLS_INTEGER;
\n<\/em>BEGIN
\n<\/em>DBMS_RESOURCE_MANAGER.calibrate_io (
\n<\/em>\u00a0\u00a0\u00a0 num_physical_disks => 13,
\n<\/em>\u00a0\u00a0\u00a0 max_latency\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 => 20,
\n<\/em>\u00a0\u00a0\u00a0 max_iops\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 => l_max_iops,
\n<\/em>\u00a0\u00a0\u00a0 max_mbps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 => l_max_mbps,
\n<\/em>\u00a0\u00a0\u00a0 actual_latency\u00a0\u00a0\u00a0\u00a0 => l_actual_latency);
\n<\/em>\u00a0 DBMS_OUTPUT.put_line (‚l_max_iops\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‚ || l_max_iops);
\n<\/em>\u00a0 DBMS_OUTPUT.put_line (‚l_max_mbps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‚ || l_max_mbps);
\n<\/em>\u00a0 DBMS_OUTPUT.put_line (‚l_actual_latency = ‚ || l_actual_latency);
\n<\/em>END;
\n<\/em>\/<\/em><\/h5>\n
l_max_iops\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 5291
\n<\/em>l_max_mbps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 1127
\n<\/em>l_actual_latency = 19<\/em><\/h5>\n

\n<\/em>PL\/SQL procedure successfully completed.<\/em><\/h5>\n
\nSQL> SELECT * FROM dba_rsrc_io_calibrate;<\/h5>\n
START_TIME END_TIME MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY NUM_PHYSICAL_DISKS
\n—————————— —————————— ———- ———- ———- ———- ——————
\n02-APR-17 11.13.13.218026 AM 02-APR-17 11.20.13.792305 AM 5291 1127 602 19 13<\/h5>\n

 <\/p>\n

Status ausgeben:
\nselect status from V$IO_CALIBRATION_STATUS;<\/h5>\n
Anzahl der Disken: Festplatten auf den Datenbankfiles liegen (nur eine entsprechende Gr\u00f6\u00dfenordnung)<\/h5>\n
Maximale Latenzzeit: Der Wert muss gr\u00f6\u00dfer als der zu erwartende \u00a0Wert sein (minimal 10).<\/h5>\n

 <\/p>\n

Hinweis:<\/p>\n

Evtl. ist der init.ora-Parameter DNFS_BATCH_SIZE zu setzen (ORA-56719: Error spawning or communicating with calibration slave).<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

Das\u00a0DBMS_RESOURCE_MANAGER Paket beinhaltet die „CALIBRATE_IO“-Prozedur mit der belastbare I\/O-Statistiken zu den angebundenen Filesystemen ermittelt werden k\u00f6nnen. Beispiel: SET SERVEROUTPUT ON DECLARE \u00a0 l_max_iops\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PLS_INTEGER; \u00a0 l_max_mbps\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PLS_INTEGER; \u00a0 l_actual_latency\u00a0 PLS_INTEGER; BEGIN DBMS_RESOURCE_MANAGER.calibrate_io ( \u00a0\u00a0\u00a0 num_physical_disks => 13, \u00a0\u00a0\u00a0 max_latency\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 => … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[31],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/416"}],"collection":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=416"}],"version-history":[{"count":3,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/416\/revisions"}],"predecessor-version":[{"id":419,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/416\/revisions\/419"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}