{"id":323,"date":"2022-04-11T13:03:49","date_gmt":"2022-04-11T05:03:49","guid":{"rendered":"https:\/\/www.db2go.net\/?p=323"},"modified":"2022-04-11T13:15:23","modified_gmt":"2022-04-11T05:15:23","slug":"%e5%88%a9%e7%94%a8dbms_resource_manager-calibrate_io%e7%bb%99%e7%a3%81%e7%9b%98%e5%81%9a%e5%9f%ba%e5%87%86%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/www.db2go.net\/?p=323","title":{"rendered":"\u5229\u7528dbms_resource_manager.calibrate_io\u7ed9\u78c1\u76d8\u505a\u57fa\u51c6\u6d4b\u8bd5"},"content":{"rendered":"<p>\u9664\u4e86\u4f7f\u7528Oracle\u63d0\u4f9b\u7684Orion\u5de5\u5177\u505a\u57fa\u51c6\u6d4b\u8bd5\u5916\uff0c\u8fd8\u53ef\u4ee5\u5229\u752811g\u63d0\u4f9b\u7684\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b DBMS_RESOURCE_MANAGER.CALIBRATE_IO \u7ed9\u78c1\u76d8\u505a\u57fa\u51c6\u6d4b\u8bd5\u3002<br \/>\nSQL\u5982\u4e0b\uff1a<\/p>\n<pre><code class=\"language-SQL line-numbers\">SQL&gt; SET SERVEROUTPUT ON\nDECLARE\nlat INTEGER;\niops INTEGER;\nmbps INTEGER;\nBEGIN\nDBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 10, iops, mbps, lat);\nDBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);\nDBMS_OUTPUT.PUT_LINE ('latency = ' || lat);\ndbms_output.put_line('max_mbps = ' || mbps);\nend;\n\/\nSQL&gt;   2    3    4    5    6    7    8    9   10   11  \n\nmax_iops = 1205758\nlatency = 0\nmax_mbps = 24515\n\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\n<p>\u8f93\u51fa\u4fe1\u606f\u4e2d\u7684max_iops=1205758\uff0c\u8bf4\u660eIO\u5b50\u7cfb\u7edf\u7684\u6bcf\u79d2IO\u8bf7\u6c42\u6b21\u6570\u662f1205758\u6b21\uff0clatency=0\uff0c\u8bf4\u660eI\/O\u5b50\u7cfb\u7edf\u7684\u5ef6\u8fdf\u662f0ms\u3002max_mbps=24515\uff0c\u8bf4\u660e\u6bcf\u79d2\u7684\u6700\u5927\u5904\u7406\u80fd\u529b\u662f24515MB\u3002<\/p>\n<p>\u5728calibrate_io\u6267\u884c\u65f6\u53ef\u4ee5\u67e5\u770b\u5176\u72b6\u6001<\/p>\n<pre><code class=\"language-sql line-numbers\">SQL&gt;  select * from V$IO_CALIBRATION_STATUS;\n\nSTATUS                     CALIBRATION_TIME\n-------------------------- ------------------------------\nIN PROGRESS                11-APR-22 12.39.59.254 PM\n\n<\/code><\/pre>\n<p>\u5728dbms_resource_manager.calibrate_io\u6267\u884c\u5b8c\u540e\u53ef\u4ee5\u67e5\u770b\u5176\u7ed3\u679c<\/p>\n<pre><code class=\"language-sql line-numbers\">SQL&gt;  set lines 200\nSQL&gt;  col START_TIME format a30 \nSQL&gt; col END_TIME format a30\nSQL&gt;  select * from DBA_RSRC_IO_CALIBRATE;\n\nSTART_TIME                     END_TIME                         MAX_IOPS   MAX_MBPS  MAX_PMBPS    LATENCY NUM_PHYSICAL_DISKS\n------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ------------------\n11-APR-22 12.30.28.943630 PM   11-APR-22 12.39.59.254063 PM      1205758      24515       6501          0                  2\n<\/code><\/pre>\n<p><a class=\"wp-editor-md-post-content-link\" href=\"https:\/\/www.db2go.net\/wp-content\/uploads\/2022\/04\/wp_editor_md_cf69dae3abe49e306b8bd92b4fe26f1c.jpg\"><img decoding=\"async\" src=\"https:\/\/www.db2go.net\/wp-content\/uploads\/2022\/04\/wp_editor_md_cf69dae3abe49e306b8bd92b4fe26f1c.jpg\" alt=\"\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9664\u4e86\u4f7f\u7528Oracle\u63d0\u4f9b\u7684Orion\u5de5\u5177\u505a\u57fa\u51c6\u6d4b\u8bd5\u5916\uff0c\u8fd8\u53ef\u4ee5\u5229\u752811g\u63d0\u4f9b\u7684\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b DBMS_RESOU&hellip;<\/p>\n <a href=\"https:\/\/www.db2go.net\/?p=323\" title=\"\u5229\u7528dbms_resource_manager.calibrate_io\u7ed9\u78c1\u76d8\u505a\u57fa\u51c6\u6d4b\u8bd5\" class=\"entry-more-link\"><span>Read More<\/span> <span class=\"screen-reader-text\">\u5229\u7528dbms_resource_manager.calibrate_io\u7ed9\u78c1\u76d8\u505a\u57fa\u51c6\u6d4b\u8bd5<\/span><\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"Layout":"","footnotes":""},"categories":[4],"tags":[],"class_list":["entry","author-suredandan","post-323","post","type-post","status-publish","format-standard","category-oracle"],"views":1877,"_links":{"self":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts\/323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=323"}],"version-history":[{"count":4,"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts\/323\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts\/323\/revisions\/327"}],"wp:attachment":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}