{"id":1567,"date":"2021-06-23T15:45:19","date_gmt":"2021-06-23T07:45:19","guid":{"rendered":"http:\/\/www.821121.com\/?p=1567"},"modified":"2021-07-08T17:48:19","modified_gmt":"2021-07-08T09:48:19","slug":"oracle%e6%95%b0%e6%8d%ae%e5%ba%93i-o%e6%b5%8b%e8%af%95%e8%84%9a%e6%9c%ac","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1567","title":{"rendered":"oracle\u6570\u636e\u5e93I\/O\u6d4b\u8bd5\u811a\u672c"},"content":{"rendered":"<p>export ORACLE_SID=trustDB1<br \/>\nsqlplus -s &quot;\/ as sysdba&quot; &lt;&lt;EOF<br \/>\nspool \/home\/oracle\/iostat.log append<br \/>\nalter session set nls_date_format='DD\/Mon\/YYYY HH24:MI:SS';<br \/>\nselect sysdate from dual;<br \/>\nSET SERVEROUTPUT ON<br \/>\nDECLARE<br \/>\nlat  INTEGER;<br \/>\niops INTEGER;<br \/>\nmbps INTEGER;<br \/>\nBEGIN<br \/>\n-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat);<br \/>\nDBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 100, iops, mbps, lat);<\/p>\n<p>DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);<br \/>\nDBMS_OUTPUT.PUT_LINE ('latency  = ' || lat);<br \/>\nDBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps);<br \/>\nend;<br \/>\n\/<br \/>\nselect sysdate from dual;<br \/>\nexit;<br \/>\nEOF<\/p>\n","protected":false},"excerpt":{"rendered":"<p>export ORACLE_SID=trustDB<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,19,48,34],"tags":[],"class_list":["post-1567","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-oracle-12c","category-sql","category-34"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1567"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1567\/revisions"}],"predecessor-version":[{"id":1568,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1567\/revisions\/1568"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1567"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}