{"id":1739,"date":"2024-05-09T14:43:34","date_gmt":"2024-05-09T06:43:34","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1739"},"modified":"2024-05-09T14:43:34","modified_gmt":"2024-05-09T06:43:34","slug":"oracle-awr%e6%8a%a5%e5%91%8a%e7%94%9f%e6%88%90%e5%92%8c%e6%80%a7%e8%83%bd%e5%88%86%e6%9e%90","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1739","title":{"rendered":"Oracle AWR\u62a5\u544a\u751f\u6210\u548c\u6027\u80fd\u5206\u6790"},"content":{"rendered":"<article class=\"_2rhmJa\">\n<h2>\u4e00\u3001AWE\u62a5\u544a\u751f\u6210\u6b65\u9aa4<\/h2>\n<p>\u5bf9\u4e8eSQL\u8c03\u4f18\uff0c\u5c40\u90e8SQL\uff0c\u6211\u4eec\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u6267\u884c\u8ba1\u5212\u7b49\u76f4\u63a5\u8c03\u4f18\uff0c\u800c\u5bf9\u4e8e\u6574\u4e2a\u7cfb\u7edf\u6765\u8bf4\uff1f\u8fd9\u65f6\u5019\u5c31\u53ef\u4ee5\u7528Oracle\u7cfb\u7edf\u81ea\u5e26\u7684\u62a5\u544a\u5bf9\u7cfb\u7edf\u8fdb\u884c\u6574\u4f53\u5206\u6790\u4e86\uff0cOracle\u63d0\u4f9b\u597d\u51e0\u79cd\u6027\u80fd\u5206\u6790\u7684\u62a5\u544a\uff0c\u6bd4\u5982AWR\u3001ASH\u3001ADDM\u7b49\u7b49<br \/>\n\u8fd9\u7bc7\u535a\u5ba2\u4e3b\u8981\u4ecb\u7ecdAWR<\/p>\n<p>AWR\u5168\u79f0Automatic Workload Repository\uff0c\u81ea\u52a8\u8d1f\u8f7d\u4fe1\u606f\u5e93\uff0c\u662fOracle 10g\u7248\u672c\u540e\u63a8\u51fa\u7684\u4e00\u79cd\u6027\u80fd\u6536\u96c6\u548c\u5206\u6790\u5de5\u5177\uff0c\u63d0\u4f9b\u4e86\u4e00\u4e2a\u65f6\u95f4\u6bb5\u5185\u6574\u4e2a\u7cfb\u7edf\u7684\u62a5\u8868\u6570\u636e\u3002\u901a\u8fc7AWR\u62a5\u544a\uff0c\u53ef\u4ee5\u5206\u6790\u6307\u5b9a\u7684\u65f6\u95f4\u6bb5\u5185\u6570\u636e\u5e93\u7cfb\u7edf\u7684\u6027\u80fd\u3002<\/p>\n<h3>1.1 \u5de5\u5177\u9009\u62e9<\/h3>\n<p>\u5bf9\u4e8eOracle\u6570\u636e\u5e93\u53ef\u4ee5\u4f7f\u7528sqlplus\u6216\u8005plsql developer\u5ba2\u6237\u7aef\u8f6f\u4ef6<br \/>\n<strong>sqlplus \u4f7f\u7528<\/strong><br \/>\n\u53ef\u4ee5\u4f7f\u7528sqlplus\u5de5\u5177\u767b\u5f55<br \/>\n\u8fdb\u5165\u6570\u636e\u5e93<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-csharp\"><code class=\"  language-csharp\">sqlplus <span class=\"token operator\">\/<\/span> <span class=\"token keyword\">as<\/span> sysdba\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u67e5\u770b\u7528\u6237<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-dart\"><code class=\"  language-dart\">show parameter db_name\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u7528\u767b\u5f55\u4e4b\u540e\u624d\u53ef\u4ee5\u4f7f\u7528<br \/>\n<strong>plsql developer\u4f7f\u7528<\/strong><br \/>\nplsql developer\u4e5f\u53ef\u4ee5\u4f7f\u7528\uff0c\u767b\u5f55\u4e4b\u540e\uff0c\u9009\u62e9\u6587\u4ef6(File)-&gt;\u65b0\u5efa(New)-&gt;\u547d\u4ee4\u7a97\u53e3(Command Window)\n<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 700px; max-height: 688px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 52.68000000000001%;\"><\/div>\n<div class=\"image-view\" data-width=\"1306\" data-height=\"688\"><img decoding=\"async\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/2567753-1ec0afd310562675\" data-original-width=\"1306\" data-original-height=\"688\" data-original-format=\"image\/png\" data-original-filesize=\"127546\" data-image-index=\"0\" style=\"cursor: zoom-in;\" class=\"\" src=\"\/\/upload-images.jianshu.io\/upload_images\/2567753-1ec0afd310562675?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/1200\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<h3>1.2 \u81ea\u52a8\u521b\u5efa\u5feb\u7167<\/h3>\n<p>\u5f00\u59cb\u538b\u6d4b\u540e\u6267\u884c<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-bash\"><code class=\"  language-bash\">exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u53ef\u4ee5\u901a\u8fc7dba_hist_wr_control\u67e5\u770b\u5f53\u524d\u7684\u914d\u7f6e\u60c5\u51b5\uff0c\u5f53\u524dawr\u4e3a\u6bcf1\u5c0f\u65f6\u505a\u4e00\u6b21\u6570\u636e\u5feb\u7167\uff0c\u4fdd\u7559\u65f6\u95f4\u4e3a8\u5929\u3002<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-csharp\"><code class=\"  language-csharp\"> <span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> dba_hist_wr_control<span class=\"token punctuation\">;<\/span>\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 589px; max-height: 239px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 40.58%;\"><\/div>\n<div class=\"image-view\" data-width=\"589\" data-height=\"239\"><img decoding=\"async\" data-original-src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-1ec0afd310562675?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/1200\/format\/webp\" data-original-width=\"589\" data-original-height=\"239\" data-original-format=\"image\/png\" data-original-filesize=\"23553\" data-image-index=\"1\" style=\"cursor: zoom-in;\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-1ec0afd310562675?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/1200\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<p><\/p>\n<p>\u4fee\u6539\u914d\u7f6e\uff0c\u6bcf\u969430\u5206\u949f\u6536\u96c6\u4e00\u6b21\uff0c\u4fdd\u5b581\u5929<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-tsx\"><code class=\"  language-tsx\">execute dbms_workload_repository<span class=\"token punctuation\">.<\/span><span class=\"token function\">modify_snapshot_settings<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">interval<\/span><span class=\"token operator\">=&gt;<\/span><span class=\"token number\">30<\/span><span class=\"token punctuation\">,<\/span><span class=\"token parameter\">retention<\/span><span class=\"token operator\">=&gt;<\/span><span class=\"token number\">14000<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u5173\u95edAWR\u81ea\u52a8\u6536\u96c6<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-tsx\"><code class=\"  language-tsx\"><span class=\"token constant\">SQL<\/span><span class=\"token operator\">&gt;<\/span>exec dbms_workload_repository<span class=\"token punctuation\">.<\/span><span class=\"token function\">modify_snapshot_settings<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token parameter\">interval<\/span><span class=\"token operator\">=&gt;<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span><span class=\"token parameter\">retention<\/span><span class=\"token operator\">=&gt;<\/span><span class=\"token number\">24<\/span><span class=\"token operator\">*<\/span><span class=\"token number\">60<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u6ce8\uff1a10g\u9ed8\u8ba4\u662f\u81ea\u52a8\u5f00\u542fawr\u4fe1\u606f\u6536\u96c6\u7684\uff0c\u4f1a\u5bf9\u7cfb\u7edf\u6709\u4e00\u5b9a\u7684\u5f71\u54cd\uff08\u5f88\u5c0f\uff09\uff1b\u5982\u679c\u8981\u5173\u95edawr\u4fe1\u606f\u6536\u96c6\uff0c\u53ea\u9700\u8bbe\u7f6einterval\u53c2\u6570\u4e3a0\u5373\u53ef\u3002\u4f46interval\u8bbe0\u540e\uff0cAWR\u62a5\u544a\u65e0\u6cd5\u751f\u6210\u3002<\/p>\n<h3>1.3 \u624b\u5de5\u521b\u5efa\u5feb\u7167<\/h3>\n<p>\u9664\u4e86\u81ea\u52a8\u521b\u5efa\u5feb\u7167\uff0c\u4e5f\u53ef\u4ee5\u624b\u5de5\u521b\u5efa\u5feb\u7167<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-csharp\"><code class=\"  language-csharp\"><span class=\"token keyword\">select<\/span> dbms_workload_repository<span class=\"token punctuation\">.<\/span><span class=\"token function\">create_snapshot<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">from<\/span> dual<span class=\"token punctuation\">;<\/span>\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<h3>1.4 \u751f\u6210AWR\u62a5\u544a<\/h3>\n<p>\u5728sqlplus\u6216\u8005plsql\u4f7f\u7528\u547d\u4ee4\uff0c${ORACLE_HOME}\u662fOracle\u7684\u5b89\u88c5\u8def\u5f84<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-bash\"><code class=\"  language-bash\">@\/${ORACLE_HOME}\/...\/RDBMS\/ADMIN\/awrrpt.sql\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u4f8b\u5982\u6211\u7684\u547d\u4ee4\u4e3a\uff1a<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-ruby\"><code class=\"  language-ruby\"><span class=\"token variable\">@D<\/span><span class=\"token punctuation\">:<\/span><span class=\"token operator\">\/<\/span>oracle<span class=\"token operator\">\/<\/span>product<span class=\"token operator\">\/<\/span><span class=\"token number\">11.1<\/span><span class=\"token number\">.0<\/span><span class=\"token operator\">\/<\/span>db_1<span class=\"token operator\">\/<\/span><span class=\"token constant\">RDBMS<\/span><span class=\"token operator\">\/<\/span><span class=\"token constant\">ADMIN<\/span><span class=\"token operator\">\/<\/span>awrrpt<span class=\"token punctuation\">.<\/span>sql\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>sqlplus\u767b\u5f55\u7684\u53ef\u4ee5\u4f7f\u7528<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-css\"><code class=\"  language-css\">@?\/rdbms\/admin\/awrrpt\/awrrpt.sql\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p><strong>@?\/rdbms\/admin\/awrrpt;  \u672c\u5b9e\u4f8bAWR\u5305\u62ec\uff1a<\/strong><br \/>\n@?\/rdbms\/admin\/awrrpti; RAC\u4e2d\u9009\u62e9\u5b9e\u4f8b\u53f7<br \/>\n@?\/rdbms\/admin\/awrddrpt; AWR \u6bd4\u5bf9\u62a5\u544a<br \/>\n@?\/RDBMS\/admin\/awrgrpt; RAC\u5168\u5c40AWR\u62a5\u544a<\/p>\n<p>\u6267\u884c\u547d\u4ee4\u4e4b\u540e\uff0c\u4f1a\u63d0\u793a\u4f60\u8f93\u5165\u4e00\u4e9b\u53c2\u6570<\/p>\n<ul>\n<li>(1) Enter value   of report_type<br \/>\n\u610f\u601d\u662f\u751f\u6210\u62a5\u544a\u7684\u683c\u5f0f\u6709\u4e24\u79cd\uff0chtml\u548ctxt\uff0c\u8fd9\u91cc\u9009\u62e9html<\/li>\n<li>(2) Enter value of num_days<br \/>\n\u6536\u96c6\u51e0\u5929\u7684\u62a5\u544a\u4fe1\u606f\uff0c\u6570\u5b57\uff0c\u53ef\u4ee5\u8f93\u51651<\/li>\n<li>(3) Enter value of begin_snap<br \/>\n\u8f93\u5165\u5f00\u59cb\u5feb\u7167id\uff0c\u8981\u6839\u636e\u65e5\u5fd7\u6253\u5370\u7684\u5feb\u7167id\u8303\u56f4\u6765\u586b<\/li>\n<\/ul>\n<p>\u4f8b\u5982\u6211\u5b9e\u9a8c\u65f6\u5019\uff0c\u65e5\u5fd7\u6253\u5370\u7684\u5feb\u7167id\u8303\u56f4\u4e3a\uff1a6727 ~6745<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-rust\"><code class=\"  language-rust\">\n    Listing the last day<span class=\"token lifetime-annotation symbol\">'s<\/span> Completed Snapshots \n\nINST_NAME    DB_NAME       SNAP_ID SNAPDAT            LV\n<span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span>\norcl        ORCL              <span class=\"token number\">6727<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">00<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6728<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">01<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6729<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">02<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6730<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">03<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6731<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">04<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6732<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">05<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6733<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">06<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6734<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">07<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6735<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">08<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6736<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">09<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6737<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6738<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">11<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6739<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">12<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6740<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">13<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6741<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6742<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">13<\/span>  <span class=\"token number\">1<\/span>\norcl        ORCL              <span class=\"token number\">6743<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">15<\/span>  <span class=\"token number\">1<\/span>\norcl        OANET            <span class=\"token number\">6744<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">16<\/span>  <span class=\"token number\">1<\/span>\norcl        OANET            <span class=\"token number\">6745<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">40<\/span>  <span class=\"token number\">1<\/span>\n\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u6240\u4ee5\u6211\u968f\u610f\u586b\u5199\uff1a6743<\/p>\n<ul>\n<li>(4) Enter value of end_snap<br \/>\n\u8f93\u5165\u7ed3\u675f\u5feb\u7167id\uff0c\u8981\u6839\u636e\u65e5\u5fd7\u6253\u5370\u7684\u5feb\u7167id\u8303\u56f4\u6765\u586b\uff0c\u6240\u4ee5\u6211\u968f\u610f\u586b\u5199\uff1a6745<\/li>\n<\/ul>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i aria-label=\"icon: copy\" class=\"anticon anticon-copy\"><svg viewBox=\"64 64 896 896\" focusable=\"false\" class=\"\" data-icon=\"copy\" width=\"1em\" height=\"1em\" fill=\"currentColor\" aria-hidden=\"true\"><path d=\"M832 64H296c-4.4 0-8 3.6-8 8v56c0 4.4 3.6 8 8 8h496v688c0 4.4 3.6 8 8 8h56c4.4 0 8-3.6 8-8V96c0-17.7-14.3-32-32-32zM704 192H192c-17.7 0-32 14.3-32 32v530.7c0 8.5 3.4 16.6 9.4 22.6l173.3 173.3c2.2 2.2 4.7 4 7.4 5.5v1.9h4.2c3.5 1.3 7.2 2 11 2H704c17.7 0 32-14.3 32-32V224c0-17.7-14.3-32-32-32zM350 856.2L263.9 770H350v86.2zM664 888H414V746c0-22.1-17.9-40-40-40H232V264h432v624z\"><\/path><\/svg><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-ruby\"><code class=\"  language-ruby\"><span class=\"token constant\">SQL<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token variable\">@D<\/span><span class=\"token punctuation\">:<\/span><span class=\"token operator\">\/<\/span>oracle<span class=\"token operator\">\/<\/span>product<span class=\"token operator\">\/<\/span><span class=\"token number\">11.1<\/span><span class=\"token number\">.0<\/span><span class=\"token operator\">\/<\/span>db_1<span class=\"token operator\">\/<\/span><span class=\"token constant\">RDBMS<\/span><span class=\"token operator\">\/<\/span><span class=\"token constant\">ADMIN<\/span><span class=\"token operator\">\/<\/span>awrrpt<span class=\"token punctuation\">.<\/span>sql\n\n<span class=\"token constant\">Current<\/span> <span class=\"token constant\">Instance<\/span>\n<span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span>\n\n      <span class=\"token constant\">DBID<\/span> <span class=\"token constant\">DB_NAME<\/span>      <span class=\"token constant\">INST_<\/span> <span class=\"token constant\">INST_NAME<\/span>\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span>\n<span class=\"token number\">4279242421<\/span> <span class=\"token constant\">ORCL<\/span>            <span class=\"token number\">1<\/span> orcl\nrpt_options\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">0<\/span>\n\n<span class=\"token constant\">Specify<\/span> the <span class=\"token constant\">Report<\/span> <span class=\"token constant\">Type<\/span>\n<span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span>\n<span class=\"token constant\">Would<\/span> you like an <span class=\"token constant\">HTML<\/span> report<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">or<\/span> a plain text report<span class=\"token operator\">?<\/span>\n<span class=\"token constant\">Enter<\/span> <span class=\"token string\">'html'<\/span> <span class=\"token keyword\">for<\/span> an <span class=\"token constant\">HTML<\/span> report<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">or<\/span> <span class=\"token string\">'text'<\/span> <span class=\"token keyword\">for<\/span> plain text\n<span class=\"token constant\">Defaults<\/span> to <span class=\"token string\">'html'<\/span>\n<span class=\"token constant\">Type<\/span> <span class=\"token constant\">Specified<\/span><span class=\"token punctuation\">:<\/span>  html\n<span class=\"token constant\">Cannot<\/span> <span class=\"token constant\">SET<\/span> <span class=\"token constant\">TRIMSPOOL<\/span>\n<span class=\"token constant\">Cannot<\/span> <span class=\"token constant\">SET<\/span> <span class=\"token constant\">UNDERLINE<\/span>\n\n<span class=\"token constant\">Instances<\/span> <span class=\"token keyword\">in<\/span> this <span class=\"token constant\">Workload<\/span> <span class=\"token constant\">Repository<\/span> schema\n<span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span>\n\n<span class=\"token constant\">DBBID<\/span>        <span class=\"token constant\">INSTT<\/span> <span class=\"token constant\">DBB_NAME<\/span>     <span class=\"token constant\">INSTT_NAME<\/span>   <span class=\"token constant\">HOST<\/span>\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span>\n<span class=\"token operator\">*<\/span> <span class=\"token number\">4279242421<\/span>     <span class=\"token number\">1<\/span> <span class=\"token constant\">ORCL<\/span>        <span class=\"token constant\">ORCL<\/span>        zwdb\n\n<span class=\"token constant\">Using<\/span> <span class=\"token number\">4279242421<\/span> <span class=\"token keyword\">for<\/span> database <span class=\"token constant\">Id<\/span>\n<span class=\"token constant\">Using<\/span> <span class=\"token number\">1<\/span> <span class=\"token keyword\">for<\/span> instance number\ndbid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">4279242421<\/span>\ninst_num\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">1<\/span>\ninst_num\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">1<\/span>\ndbid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">4279242421<\/span>\nmax_snap_time\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">17<\/span><span class=\"token operator\">\/<\/span><span class=\"token number\">04<\/span><span class=\"token operator\">\/<\/span><span class=\"token number\">2019<\/span>\n\n<span class=\"token constant\">Specify<\/span> the number of days of snapshots to choose from\n<span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span>\n<span class=\"token constant\">Entering<\/span> the number of days <span class=\"token punctuation\">(<\/span>n<span class=\"token punctuation\">)<\/span> will result <span class=\"token keyword\">in<\/span> the most recent\n<span class=\"token punctuation\">(<\/span>n<span class=\"token punctuation\">)<\/span> days of snapshots being listed<span class=\"token punctuation\">.<\/span>  <span class=\"token constant\">Pressing<\/span> <span class=\"token operator\">&lt;<\/span><span class=\"token keyword\">return<\/span><span class=\"token operator\">&gt;<\/span> without\nspecifying a number lists all completed snapshots<span class=\"token punctuation\">.<\/span>\n\n<span class=\"token constant\">Listing<\/span> the last day's <span class=\"token constant\">Completed<\/span> <span class=\"token constant\">Snapshots<\/span> \n\n<span class=\"token constant\">INST_NAME<\/span>    <span class=\"token constant\">DB_NAME<\/span>       <span class=\"token constant\">SNAP_ID<\/span> <span class=\"token constant\">SNAPDAT<\/span>            <span class=\"token constant\">LV<\/span>\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span> <span class=\"token operator\">--<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6727<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">00<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6728<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">01<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6729<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">02<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6730<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">03<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6731<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">04<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6732<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">05<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6733<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">06<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6734<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">07<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6735<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">08<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6736<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">09<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6737<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6738<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">11<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6739<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">12<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6740<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">13<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6741<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">00<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6742<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">13<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">ORCL<\/span>              <span class=\"token number\">6743<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">15<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">OANET<\/span>            <span class=\"token number\">6744<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">16<\/span>  <span class=\"token number\">1<\/span>\norcl        <span class=\"token constant\">OANET<\/span>            <span class=\"token number\">6745<\/span> <span class=\"token number\">17<\/span> <span class=\"token number\">4<\/span>\u6708  <span class=\"token number\">2019<\/span> <span class=\"token number\">14<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">40<\/span>  <span class=\"token number\">1<\/span>\ndbid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">4279242421<\/span>\ninst_num\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">1<\/span>\nmax_snap_time\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">17<\/span><span class=\"token operator\">\/<\/span><span class=\"token number\">04<\/span><span class=\"token operator\">\/<\/span><span class=\"token number\">2019<\/span>\n\n<span class=\"token constant\">Specify<\/span> the <span class=\"token constant\">Begin<\/span> <span class=\"token keyword\">and<\/span> <span class=\"token constant\">End<\/span> <span class=\"token constant\">Snapshot<\/span> <span class=\"token constant\">Ids<\/span>\n<span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span>\n<span class=\"token constant\">Begin<\/span> <span class=\"token constant\">Snapshot<\/span> <span class=\"token constant\">Id<\/span> specified<span class=\"token punctuation\">:<\/span> <span class=\"token number\">6743<\/span>\n\n<span class=\"token constant\">End<\/span>   <span class=\"token constant\">Snapshot<\/span> <span class=\"token constant\">Id<\/span> specified<span class=\"token punctuation\">:<\/span> <span class=\"token number\">6745<\/span>\n\nbid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">6743<\/span>\neid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">6745<\/span>\n\ninst_num\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">1<\/span>\ndbid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">4279242421<\/span>\nbid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">6743<\/span>\neid\n<span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">--<\/span><span class=\"token operator\">-<\/span>\n<span class=\"token number\">6745<\/span>\n<span class=\"token constant\">Cannot<\/span> <span class=\"token constant\">SET<\/span> <span class=\"token constant\">TRIMSPOOL<\/span>\n<span class=\"token constant\">Cannot<\/span> <span class=\"token constant\">SET<\/span> <span class=\"token constant\">UNDERLINE<\/span>\n\n<span class=\"token constant\">Specify<\/span> the <span class=\"token constant\">Report<\/span> <span class=\"token constant\">Name<\/span>\n<span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span><span class=\"token operator\">~<\/span>\n<span class=\"token constant\">The<\/span> default report file name is awrrpt_1_6743_6745<span class=\"token punctuation\">.<\/span>html<span class=\"token punctuation\">.<\/span>  <span class=\"token constant\">To<\/span> use this name<span class=\"token punctuation\">,<\/span>\npress <span class=\"token operator\">&lt;<\/span><span class=\"token keyword\">return<\/span><span class=\"token operator\">&gt;<\/span> to continue<span class=\"token punctuation\">,<\/span> otherwise enter an alternative<span class=\"token punctuation\">.<\/span>\n\n<span class=\"token constant\">Using<\/span> the report name awr<span class=\"token punctuation\">.<\/span>html \n<span class=\"token constant\">Started<\/span> spooling to <span class=\"token constant\">D<\/span><span class=\"token punctuation\">:<\/span>\\<span class=\"token constant\">Program<\/span> <span class=\"token constant\">Files<\/span>\\<span class=\"token constant\">PLSQL<\/span> <span class=\"token constant\">Developer<\/span> <span class=\"token number\">8.0<\/span><span class=\"token number\">.3<\/span><span class=\"token number\">.1510<\/span>\\awr<span class=\"token punctuation\">.<\/span>html\n<span aria-hidden=\"true\" class=\"line-numbers-rows\"><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><span><\/span><\/span><\/code><\/pre>\n<\/div>\n<h2>\u4e8c\u3001AWR\u62a5\u544a\u5206\u6790<\/h2>\n<h3>2.1 AWR\u4e4bDB Time<\/h3>\n<p>DB Time\u4e3b\u8981\u7528\u6765\u5224\u65ad\u5f53\u524d\u7cfb\u7edf\u6709\u6ca1\u6709\u76f8\u5173\u74f6\u9888\uff0c\u662f\u5426\u8f83\u4e3a\u9891\u7e41\u8bbf\u95ee\u7cfb\u7edf\u5bfc\u81f4\u7b49\u5f85\u65f6\u95f4\u5f88\u957f\uff1f\u7136\u540e\u8981\u600e\u4e48\u770b\uff1f\u4e00\u822c\u6765\u8bf4\uff0cElapsed\u65f6\u95f4\u4e58\u4ee5CPU\u4e2a\u6570\u5982\u679c\u5927\u4e8eDB Time\uff0c\u5c31\u662f\u6b63\u5e38\u7684\uff0c\u7cfb\u7edf\u538b\u529b\u4e0d\u5927\uff0c\u53cd\u4e4b\u5c31\u8bf4\u660e\u538b\u529b\u8f83\u5927\uff0c\u4f8b\u5b50\u5982\u56fe\uff0c24.93*8\u5f88\u660e\u663e\u5927\u4e8e0.49\uff0c\u6240\u4ee5\u8bf4\u660e\u7cfb\u7edf\u538b\u529b\u5f88\u5c0f<\/p>\n<p><\/p>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 685px; max-height: 232px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 33.87%;\"><\/div>\n<div class=\"image-view\" data-width=\"685\" data-height=\"232\"><img decoding=\"async\" data-original-src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-8c51c9a628fadea8?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/589\/format\/webp\" data-original-width=\"685\" data-original-height=\"232\" data-original-format=\"image\/png\" data-original-filesize=\"32876\" data-image-index=\"2\" style=\"cursor: zoom-in;\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-8c51c9a628fadea8?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/589\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<h3>2.2 AWR\u4e4bload_profile<\/h3>\n<p>load_profile\u6307\u6807\u4e3b\u8981\u7528\u6765\u663e\u793a\u5f53\u524d\u7cfb\u7edf\u7684\u4e00\u4e9b\u6307\u793a\u6027\u80fd\u7684\u603b\u4f53\u53c2\u6570\uff0c\u8fd9\u91cc\u4ecb\u7ecd\u4e00\u4e9bRedo_size\uff0c\u7528\u6765\u663e\u793a\u5e73\u5747\u6bcf\u79d2\u7684\u65e5\u5fd7\u5c3a\u5bf8\u548c\u5e73\u5747\u6bcf\u4e2a\u4e8b\u52a1\u7684\u65e5\u5fd7\u5c3a\u5bf8\uff0c\u6709\u65f6\u5019\u53ef\u4ee5\u7ed3\u5408Transactions\u8fd9\u4e2a\u6bcf\u79d2\u4e8b\u52a1\u6570\uff0c<strong>\u5206\u6790\u5f53\u524d\u4e8b\u52a1\u7684\u7e41\u5fd9\u7a0b\u5ea6<\/strong><\/p>\n<p>\u5982\u56fe\uff0c\u5e73\u5747\u6bcf\u79d2\u7684\u4e8b\u52a1\u6570Transactions\u975e\u5e38\u5c0f\uff0c\u8bf4\u660e\u7cfb\u7edf\u538b\u529b\u975e\u5e38\u5c0f\uff0c\u4e00\u822c\u6765\u8bf4Transactions\u4e0d\u8d85\u8fc7200\u90fd\u662f\u6b63\u5e38\u7684\uff0c\u6216\u8005200\u5de6\u53f3\u90fd\u662f\u6b63\u5e38\u7684\uff0c\u8d85\u8fc71000\u5c31\u662f\u975e\u5e38\u7e41\u5fd9\u4e86\uff0c\u518d\u770b\u770b\u5e73\u5747\u6bcf\u79d2\u7684\u65e5\u5fd7\u5c3a\u5bf8\u662f4\u4f4d\u6570\u7684\uff0c\u5e73\u5747\u6bcf\u4e2a\u4e8b\u52a1\u7684\u65e5\u5fd7\u5c3a\u5bf8\u662f5\u4f4d\u6570\u7684\uff0c\u8bf4\u660e\u4e86\u7cfb\u7edf\u8bbf\u95ee\u4e0d\u662f\u5f88\u9891\u7e41\uff0c\u800c\u5355\u4e2a\u4e1a\u52a1\u662f\u6bd4\u8f83\u590d\u6742\u7684\uff0c\u5982\u679c\u53cd\u8fc7\u6765\uff0c\u5e73\u5747\u6bcf\u79d2\u65e5\u5fd7\u5c3a\u5bf8\u6bd4\u5e73\u5747\u6bcf\u79d2\u4e8b\u52a1\u65e5\u5fd7\u5c3a\u5bf8\u5927\u5f88\u591a\uff0c\u8bf4\u660e\u7cfb\u7edf\u8bbf\u95ee\u5f88\u9891\u7e41\uff0c\u800c\u4e1a\u52a1\u6bd4\u8f83\u7b80\u5355\uff0c\u4e0d\u9700\u8981\u54cd\u5e94\u5f88\u4e45<\/p>\n<p><\/p>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 700px; max-height: 377px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 52.35999999999999%;\"><\/div>\n<div class=\"image-view\" data-width=\"720\" data-height=\"377\"><img decoding=\"async\" data-original-src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-e7b0ffec02c7e965?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/685\/format\/webp\" data-original-width=\"720\" data-original-height=\"377\" data-original-format=\"image\/png\" data-original-filesize=\"39552\" data-image-index=\"3\" style=\"cursor: zoom-in;\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-e7b0ffec02c7e965?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/685\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<h3>2.3 AWR\u4e4befficiency percentages<\/h3>\n<p>efficiency percentages\u662f\u4e00\u4e9b\u547d\u4e2d\u7387\u6307\u6807\u3002Buffer Hint\u3001Library Hint\u7b49\u8868\u793aSGA(System global area)\u7684\u547d\u4e2d\u7387\uff1bSoft Parse\u6307\u6807\u8868\u793a\u5171\u4eab\u6c60\u7684\u8f6f\u89e3\u6790\u7387\uff0c\u5982\u679c\u5c0f\u4e8e90%\uff0c\u5c31\u8bf4\u660e\u5b58\u5728\u672a\u7ed1\u5b9a\u53d8\u91cf\u7684\u60c5\u51b5<\/p>\n<p><\/p>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 654px; max-height: 141px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 21.560000000000002%;\"><\/div>\n<div class=\"image-view\" data-width=\"654\" data-height=\"141\"><img decoding=\"async\" data-original-src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-645ad608124d9385?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/720\/format\/webp\" data-original-width=\"654\" data-original-height=\"141\" data-original-format=\"image\/png\" data-original-filesize=\"11781\" data-image-index=\"4\" style=\"cursor: zoom-in;\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-645ad608124d9385?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/720\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<h3>2.4 AWR\u4e4btop 10 events<\/h3>\n<p>Top 10 Foreground Events by Total Wait Time\uff0c\u7b49\u5f85\u4e8b\u4ef6\u662f\u8861\u91cf\u6570\u636e\u5e93\u4f18\u5316\u60c5\u51b5\u7684\u91cd\u8981\u6307\u6807\uff0c\u901a\u8fc7\u89c2\u5bdfEvent\u548c%DB time\u4e24\u5217\u5c31\u53ef\u4ee5\u76f4\u89c2\u770b\u51fa\u5f53\u524d\u6570\u636e\u5e93\u7684\u4e3b\u8981\u7b49\u5f85\u4e8b\u4ef6<br \/>\n\u5982\u56fe\u53ef\u4ee5\u770b\u51fa\u7cfb\u7edf\u9762\u8bd5\u7684\u4e3b\u8981\u662fCPU\u88ab\u5360\u7528\u592a\u591a\u4e86\u548c\u9501\u7b49\u5f85<\/p>\n<p><\/p>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 653px; max-height: 253px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 38.74%;\"><\/div>\n<div class=\"image-view\" data-width=\"653\" data-height=\"253\"><img decoding=\"async\" data-original-src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-7121e2da2bdea18a.png?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/654\/format\/webp\" data-original-width=\"653\" data-original-height=\"253\" data-original-format=\"image\/png\" data-original-filesize=\"37622\" data-image-index=\"5\" style=\"cursor: zoom-in;\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-7121e2da2bdea18a.png?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/654\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<p>### 2.5 AWR\u4e4bSQL Statistics<br \/>\nSQL Statistics\u4ece\u51e0\u4e2a\u7ef4\u5ea6\u5217\u4e3e\u4e86\u7cfb\u7edf\u6267\u884c\u6bd4\u8f83\u6162\u7684SQL\uff0c\u53ef\u4ee5\u70b9\u51fb\uff0c\u7136\u540e\u62ffSQL\u53bb\u8c03\u4f18\uff0c\u8c03\u4f18SQL\u53ef\u4ee5\u7528\u6267\u884c\u8ba1\u5212\u770b\u770b<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\" style=\"max-width: 561px; max-height: 212px; background-color: transparent;\">\n<div class=\"image-container-fill\" style=\"padding-bottom: 37.79%;\"><\/div>\n<div class=\"image-view\" data-width=\"561\" data-height=\"212\"><img decoding=\"async\" data-original-src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-fcb7823b0fa791b2?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/653\/format\/webp\" data-original-width=\"561\" data-original-height=\"212\" data-original-format=\"image\/png\" data-original-filesize=\"32582\" data-image-index=\"6\" style=\"cursor: zoom-in;\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/2567753-fcb7823b0fa791b2?imageMogr2\/auto-orient\/strip|imageView2\/2\/w\/653\/format\/webp\"><\/div>\n<\/div>\n<div class=\"image-caption\">\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0<\/div>\n<\/div>\n<p>\u5bf9\u4e8eAWR\u7684\u6027\u80fd\u6307\u6807\u8fd8\u6709\u5f88\u591a\uff0c\u672c\u535a\u5ba2\u662f\u770b\u4e86\u300a\u6536\u83b7\uff0c\u4e0d\u6b62SQL\u4f18\u5316\u300b\u4e00\u4e66\u7684\u7b14\u8bb0\uff0c\u8fd9\u91cc\u53ea\u7b80\u5355\u4ecb\u7ecd\u4e00\u4e9b\u6bd4\u8f83\u91cd\u8981\u7684\u6307\u6807<\/p>\n<\/article>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001AWE\u62a5\u544a\u751f\u6210\u6b65\u9aa4 \u5bf9\u4e8eSQL\u8c03\u4f18\uff0c\u5c40\u90e8SQL\uff0c\u6211\u4eec\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u6267\u884c\u8ba1\u5212\u7b49\u76f4\u63a5\u8c03\u4f18\uff0c\u800c\u5bf9\u4e8e\u6574\u4e2a\u7cfb\u7edf\u6765\u8bf4\uff1f\u8fd9\u65f6\u5019\u5c31\u53ef\u4ee5\u7528Oracle\u7cfb\u7edf\u81ea\u5e26\u7684\u62a5\u544a\u5bf9\u7cfb\u7edf\u8fdb\u884c\u6574\u4f53\u5206\u6790\u4e86\uff0cOracle\u63d0\u4f9b\u597d\u51e0\u79cd\u6027\u80fd\u5206\u6790\u7684\u62a5\u544a\uff0c\u6bd4\u5982AWR\u3001ASH\u3001ADDM\u7b49\u7b49 \u8fd9\u7bc7\u535a\u5ba2\u4e3b\u8981\u4ecb\u7ecdAWR AWR\u5168\u79f0Automatic Workload Repository\uff0c\u81ea\u52a8\u8d1f\u8f7d\u4fe1\u606f\u5e93\uff0c\u662fOracle 10g\u7248\u672c\u540e\u63a8\u51fa\u7684\u4e00\u79cd\u6027\u80fd\u6536\u96c6\u548c\u5206\u6790\u5de5\u5177\uff0c\u63d0\u4f9b\u4e86\u4e00\u4e2a\u65f6\u95f4\u6bb5\u5185\u6574\u4e2a\u7cfb\u7edf\u7684\u62a5\u8868\u6570\u636e\u3002\u901a\u8fc7AWR\u62a5\u544a\uff0c\u53ef\u4ee5\u5206\u6790\u6307\u5b9a\u7684\u65f6\u95f4\u6bb5\u5185\u6570\u636e\u5e93\u7cfb\u7edf\u7684\u6027\u80fd\u3002 1.1 \u5de5\u5177\u9009\u62e9 \u5bf9\u4e8eOracle\u6570\u636e\u5e93\u53ef\u4ee5\u4f7f\u7528sqlplus\u6216\u8005plsql developer\u5ba2\u6237\u7aef\u8f6f\u4ef6 sqlplus \u4f7f\u7528 \u53ef\u4ee5\u4f7f\u7528sqlplus\u5de5\u5177\u767b\u5f55 \u8fdb\u5165\u6570\u636e\u5e93 sqlplus \/ as sysdba \u67e5\u770b\u7528\u6237 show parameter db_name \u7528\u767b\u5f55\u4e4b\u540e\u624d\u53ef\u4ee5\u4f7f\u7528 plsql developer\u4f7f\u7528 plsql developer\u4e5f\u53ef\u4ee5\u4f7f\u7528\uff0c\u767b\u5f55\u4e4b\u540e\uff0c\u9009\u62e9\u6587\u4ef6(File)-&gt;\u65b0\u5efa(New)-&gt;\u547d\u4ee4\u7a97\u53e3(Command Window) \u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0 1.2 \u81ea\u52a8\u521b\u5efa\u5feb\u7167 \u5f00\u59cb\u538b\u6d4b\u540e\u6267\u884c exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); \u53ef\u4ee5\u901a\u8fc7dba_hist_wr_control\u67e5\u770b\u5f53\u524d\u7684\u914d\u7f6e\u60c5\u51b5\uff0c\u5f53\u524dawr\u4e3a\u6bcf1\u5c0f\u65f6\u505a\u4e00\u6b21\u6570\u636e\u5feb\u7167\uff0c\u4fdd\u7559\u65f6\u95f4\u4e3a8\u5929\u3002 select * from dba_hist_wr_control; \u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0 \u4fee\u6539\u914d\u7f6e\uff0c\u6bcf\u969430\u5206\u949f\u6536\u96c6\u4e00\u6b21\uff0c\u4fdd\u5b581\u5929 execute dbms_workload_repository.modify_snapshot_settings(interval=&gt;30,retention=&gt;14000); \u5173\u95edAWR\u81ea\u52a8\u6536\u96c6 SQL&gt;exec dbms_workload_repository.modify_snapshot_settings (interval=&gt;0,retention=&gt;24*60); \u6ce8\uff1a10g\u9ed8\u8ba4\u662f\u81ea\u52a8\u5f00\u542fawr\u4fe1\u606f\u6536\u96c6\u7684\uff0c\u4f1a\u5bf9\u7cfb\u7edf\u6709\u4e00\u5b9a\u7684\u5f71\u54cd\uff08\u5f88\u5c0f\uff09\uff1b\u5982\u679c\u8981\u5173\u95edawr\u4fe1\u606f\u6536\u96c6\uff0c\u53ea\u9700\u8bbe\u7f6einterval\u53c2\u6570\u4e3a0\u5373\u53ef\u3002\u4f46interval\u8bbe0\u540e\uff0cAWR\u62a5\u544a\u65e0\u6cd5\u751f\u6210\u3002 1.3 \u624b\u5de5\u521b\u5efa\u5feb\u7167 \u9664\u4e86\u81ea\u52a8\u521b\u5efa\u5feb\u7167\uff0c\u4e5f\u53ef\u4ee5\u624b\u5de5\u521b\u5efa\u5feb\u7167 select dbms_workload_repository.create_snapshot() from dual; 1.4 \u751f\u6210AWR\u62a5\u544a \u5728sqlplus\u6216\u8005plsql\u4f7f\u7528\u547d\u4ee4\uff0c${ORACLE_HOME}\u662fOracle\u7684\u5b89\u88c5\u8def\u5f84 @\/${ORACLE_HOME}\/&#8230;\/RDBMS\/ADMIN\/awrrpt.sql \u4f8b\u5982\u6211\u7684\u547d\u4ee4\u4e3a\uff1a @D:\/oracle\/product\/11.1.0\/db_1\/RDBMS\/ADMIN\/awrrpt.sql sqlplus\u767b\u5f55\u7684\u53ef\u4ee5\u4f7f\u7528 @?\/rdbms\/admin\/awrrpt\/awrrpt.sql @?\/rdbms\/admin\/awrrpt; \u672c\u5b9e\u4f8bAWR\u5305\u62ec\uff1a @?\/rdbms\/admin\/awrrpti; RAC\u4e2d\u9009\u62e9\u5b9e\u4f8b\u53f7 @?\/rdbms\/admin\/awrddrpt; AWR \u6bd4\u5bf9\u62a5\u544a @?\/RDBMS\/admin\/awrgrpt; RAC\u5168\u5c40AWR\u62a5\u544a \u6267\u884c\u547d\u4ee4\u4e4b\u540e\uff0c\u4f1a\u63d0\u793a\u4f60\u8f93\u5165\u4e00\u4e9b\u53c2\u6570 (1) Enter value of report_type \u610f\u601d\u662f\u751f\u6210\u62a5\u544a\u7684\u683c\u5f0f\u6709\u4e24\u79cd\uff0chtml\u548ctxt\uff0c\u8fd9\u91cc\u9009\u62e9html (2) Enter value of num_days \u6536\u96c6\u51e0\u5929\u7684\u62a5\u544a\u4fe1\u606f\uff0c\u6570\u5b57\uff0c\u53ef\u4ee5\u8f93\u51651 (3) Enter value of begin_snap \u8f93\u5165\u5f00\u59cb\u5feb\u7167id\uff0c\u8981\u6839\u636e\u65e5\u5fd7\u6253\u5370\u7684\u5feb\u7167id\u8303\u56f4\u6765\u586b \u4f8b\u5982\u6211\u5b9e\u9a8c\u65f6\u5019\uff0c\u65e5\u5fd7\u6253\u5370\u7684\u5feb\u7167id\u8303\u56f4\u4e3a\uff1a6727 ~6745 Listing the last day&#8217;s Completed Snapshots INST_NAME DB_NAME SNAP_ID SNAPDAT LV &#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212; orcl ORCL 6727 17 4\u6708 2019 00:00 1 orcl ORCL 6728 17 4\u6708 2019 01:00 1 orcl ORCL 6729 17 4\u6708 2019 02:00 1 orcl ORCL 6730 17 4\u6708 2019 03:00 1 orcl ORCL 6731 17 4\u6708 2019 04:00 1 orcl ORCL 6732 17 4\u6708 2019 05:00 1 orcl ORC&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[101,80],"tags":[],"class_list":["post-1739","post","type-post","status-publish","format-standard","hentry","category-101","category-80"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1739"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1739\/revisions"}],"predecessor-version":[{"id":1740,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1739\/revisions\/1740"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}