{"id":301,"date":"2021-08-01T17:14:16","date_gmt":"2021-08-01T09:14:16","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=301"},"modified":"2021-08-01T17:16:39","modified_gmt":"2021-08-01T09:16:39","slug":"oracle%e5%af%bc%e5%85%a5%e4%b8%8e%e5%af%bc%e5%87%baawr","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=301","title":{"rendered":"Oracle\u5bfc\u5165\u4e0e\u5bfc\u51faAWR"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-6a143b9d57e60\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a143b9d57e60\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#1_%E5%AF%BC%E5%87%BAAWR\" >1. \u5bfc\u51faAWR<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#11_%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\" >1.1 \u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#12_%E7%99%BB%E5%BD%95sqlplus\" >1.2 \u767b\u5f55sqlplus<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#13_%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\" >1.3. \u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#14_%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E6%89%A7%E8%A1%8C%E5%AF%BC%E5%87%BA%E5%91%BD%E4%BB%A4\" >1.4. \u5728\u6570\u636e\u5e93\u4e2d\u6267\u884c\u5bfc\u51fa\u547d\u4ee4<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#2_%E5%AF%BC%E5%85%A5AWR\" >2. \u5bfc\u5165AWR<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#21_%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\" >2.1 \u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#22_%E7%99%BB%E5%BD%95sqlplus\" >2.2 \u767b\u5f55sqlplus<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#23_%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\" >2.3. \u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#24_%E6%89%A7%E8%A1%8C%E5%AF%BC%E5%85%A5AWR%E5%91%BD%E4%BB%A4\" >2.4. \u6267\u884c\u5bfc\u5165AWR\u547d\u4ee4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/dba.qishuo.xin\/?p=301\/#25_%E5%AF%B9%E5%AF%BC%E5%85%A5%E7%9A%84AWR%E5%BF%AB%E7%85%A7%E8%BF%9B%E8%A1%8C%E9%AA%8C%E8%AF%81\" >2.5. \u5bf9\u5bfc\u5165\u7684AWR\u5feb\u7167\u8fdb\u884c\u9a8c\u8bc1<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_%E5%AF%BC%E5%87%BAAWR\"><\/span>1. \u5bfc\u51faAWR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"11_%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\"><\/span>1.1 \u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5207\u6362\u5230oracle\u7528\u6237\uff0c\u521b\u5efa\u4e00\u4e2a\u5bfc\u51fa\u6587\u4ef6\u5b58\u653e\u7684\u76ee\u5f55<\/p>\n<pre><code class=\"language-shell line-numbers\">~]# su - oracle\n~]$ mkdir -p \/home\/oracle\/expawr\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"12_%E7%99%BB%E5%BD%95sqlplus\"><\/span>1.2 \u767b\u5f55sqlplus<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5728Oracle\u7528\u6237\u4e0b\u767b\u5f55sqlplus<\/p>\n<pre><code class=\"language-shell line-numbers\">~]$\nsqlplus \/ as sysdba\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"13_%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\"><\/span>1.3. \u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql line-numbers\">SQL&gt;\ncreate directory expawr as '\/home\/oracle\/expawr';\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"14_%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E6%89%A7%E8%A1%8C%E5%AF%BC%E5%87%BA%E5%91%BD%E4%BB%A4\"><\/span>1.4. \u5728\u6570\u636e\u5e93\u4e2d\u6267\u884c\u5bfc\u51fa\u547d\u4ee4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql line-numbers\">SQL&gt; @?\/rdbms\/admin\/awrextr\n~~~~~~~~~~~~~\nAWR EXTRACT\n~~~~~~~~~~~~~\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n~  This script will extract the AWR data for a range of snapshots  ~\n~  into a dump file.  The script will prompt users for the     ~\n~  following information:                      ~\n~     (1) database id                          ~\n~     (2) snapshot range to extract                ~\n~     (3) name of directory object                 ~\n~     (4) name of dump file                    ~\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n\nDatabases in this Workload Repository schema\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n   DB Id     DB Name      Host\n------------ ------------ ------------\n* 1386205165 EASYTONG     fbyzhytqd_sr\n              v\n\n\nThe default database id is the local one: '1386205165'.  To use this\ndatabase id, press &lt;return&gt; to continue, otherwise enter an alternative.\n\n-- \u8f93\u5165\u6570\u636e\u5e93\u7684DBID\nEnter value for dbid: 1386205165\n\nUsing 1386205165 for Database ID\n\n\nSpecify the number of days of snapshots to choose from\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nEntering the number of days (n) will result in the most recent\n(n) days of snapshots being listed.  Pressing &lt;return&gt; without\nspecifying a number lists all completed snapshots.\n\n--\u8f93\u5165\u8981\u63d0\u53d6AWR\u6570\u636e\u7684\u5929\u6570\nEnter value for num_days: 5\n\nListing the last 5 days of Completed Snapshots\n\nDB Name        Snap Id    Snap Started\n------------ --------- ------------------\nEASYTONG      8429 17 Jul 2021 00:00\n              8430 17 Jul 2021 01:00\n              8431 17 Jul 2021 02:00\n\u2026\u2026\n              8543 21 Jul 2021 17:00\n              8544 21 Jul 2021 18:00\n\n-- \u8f93\u5165\u8981\u63d0\u53d6AWR\u62a5\u544a\u7684\u5f00\u59cb Snap Id\nSpecify the Begin and End Snapshot Ids\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nEnter value for begin_snap: 8429\nBegin Snapshot Id specified: 8429\n\n-- \u8f93\u5165\u8981\u63d0\u53d6AWR\u62a5\u544a\u7684\u7ed3\u675f Snap Id\nEnter value for end_snap: 8544\nEnd   Snapshot Id specified: 8544\n\n\nSpecify the Directory Name\n~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nDirectory Name             Directory Path\n------------------------------ -------------------------------------------------\nDATA_PUMP_DIR              \/u01\/app\/oracle\/admin\/easytongdb\/dpdump\/\nDIR_SHR                \/u01\/app\/ora_backups\nDPDATA                 \/home\/OracleBack\/expdpbak\nDUMP_DIR               \/home\/dpdata\nEXPAWR                 \/home\/oracle\/expawr\n\n-- \u9009\u62e9\u8981\u5bfc\u51fa\u6587\u4ef6\u5b58\u653e\u7684 Directory Name\uff08\u5927\u5c0f\u5199\u654f\u611f\uff09\nChoose a Directory Name from the above list (case-sensitive).\n\nEnter value for directory_name: EXPAWR\n\nUsing the dump directory: EXPAWR\n\nSpecify the Name of the Extract Dump File\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nThe prefix for the default dump file name is awrdat_8429_8544.\nTo use this name, press &lt;return&gt; to continue, otherwise enter\nan alternative.\n\n-- \u8f93\u5165\u5bfc\u51fa\u7684\u6587\u4ef6\u540d\uff0c\u5bfc\u51fa\u6587\u4ef6\u65f6\u4e0d\u9700\u8981\u589e\u52a0.dmp\u540e\u7f00\uff0c\u7cfb\u7edf\u4f1a\u81ea\u5df1\u52a0\u540e\u7f00\u540d\u3002\nEnter value for file_name: awrexp_20210721\n\nUsing the dump file prefix: awrexp_20210721\n|\n| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n|  The AWR extract dump file will be located\n|  in the following directory\/file:\n|   \/home\/oracle\/expawr\n|   awrexp_20210721.dmp\n| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n|\n|  *** AWR Extract Started ...\n|\n|  This operation will take a few moments. The\n|  progress of the AWR extract operation can be\n|  monitored in the following directory\/file:\n|   \/home\/oracle\/expawr\n|   awrexp_20210721.dmp.log\n|\n\nEnd of AWR Extract\n<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"2_%E5%AF%BC%E5%85%A5AWR\"><\/span>2. \u5bfc\u5165AWR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u5728\u53e6\u5916\u4e00\u53f0Oracle\u6570\u636e\u5e93\u4e2d\uff0c\u6570\u636e\u5e93\u7248\u672c\u65e0\u7279\u6b8a\u8981\u6c42\uff0c\u53ef\u4ee5\u6bd4\u6e90\u6570\u636e\u5e93\u9ad8\uff0c\u4e5f\u53ef\u4ee5\u6bd4\u6e90\u6570\u636e\u5e93\u4f4e\u3002<br \/>\n\u6211\u5bfc\u51fa\u7684\u662f11g\u6570\u636e\u5e93\u7684AWR\uff0c\u5bfc\u5165\u5230\u7684\u662f18c\u7684PDB\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n<h4><span class=\"ez-toc-section\" id=\"21_%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\"><\/span>2.1 \u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5207\u6362\u5230oracle\u7528\u6237\uff0c\u521b\u5efa\u4e00\u4e2a\u5bfc\u51fa\u6587\u4ef6\u5b58\u653e\u7684\u76ee\u5f55<\/p>\n<pre><code class=\"language-shell line-numbers\">~]# su - oracle\n~]$ mkdir -p \/home\/oracle\/expawr\n<\/code><\/pre>\n<p><strong>\u5e76\u4e14\u5c06\u7b2c1\u6b65\u4e2d\u5bfc\u51fa\u7684AWR\u6587\u4ef6<code>awrexp_20210721.dmp<\/code>\u62f7\u8d1d\u5230\u8be5\u76ee\u5f55\u4e2d\u3002<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"22_%E7%99%BB%E5%BD%95sqlplus\"><\/span>2.2 \u767b\u5f55sqlplus<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5728Oracle\u7528\u6237\u4e0b\u767b\u5f55sqlplus<\/p>\n<pre><code class=\"language-shell line-numbers\">~]$\nsqlplus \/ as sysdba\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"23_%E5%9C%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%88%9B%E5%BB%BA%E5%AF%BC%E5%87%BA%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95\"><\/span>2.3. \u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql line-numbers\">SQL&gt;\ncreate directory expawr as '\/home\/oracle\/expawr';\n<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"24_%E6%89%A7%E8%A1%8C%E5%AF%BC%E5%85%A5AWR%E5%91%BD%E4%BB%A4\"><\/span>2.4. \u6267\u884c\u5bfc\u5165AWR\u547d\u4ee4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql line-numbers\">SQL&gt; @?\/rdbms\/admin\/awrload\n~~~~~~~~~~\nAWR LOAD\n~~~~~~~~~~\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n~  This script will load the AWR data from a dump file. The   ~\n~  script will prompt users for the following information:    ~\n~     (1) name of directory object                ~\n~     (2) name of dump file                   ~\n~     (3) staging schema name to load AWR data into       ~\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nSpecify the Directory Name\n~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nDirectory Name             Directory Path\n------------------------------ -------------------------------------------------\nDATA_PUMP_DIR              \/u01\/app\/oracle\/admin\/ykt\/dpdump\/AAB092FDCE1C3CD7E053670510AC6355\nEXPAWR                 \/home\/oracle\/expawr\nEXPDPBAK               \/u01\/orabak\/\n\n\nChoose a Directory Name from the list above (case-sensitive).\n\nEnter value for directory_name: EXPAWR\n\nUsing the dump directory: EXPAWR\n\nSpecify the Name of the Dump File to Load\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nPlease specify the prefix of the dump file (.dmp) to load:\n\n-- \u9700\u8981\u662f\u5bfc\u51fa\u6587\u4ef6\u4e0d\u52a0.dmp\u540e\u7f00\u7684\u6587\u4ef6\u540d\u3002\nEnter value for file_name: awrexp_20210721\n\nLoading from the file name: awrexp_20210721.dmp\n\nStaging Schema to Load AWR Snapshot Data\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nThe next step is to create the staging schema\nwhere the AWR snapshot data will be loaded.\nAfter loading the data into the staging schema,\nthe data will be transferred into the AWR tables\nin the SYS schema.\n\n\nThe default staging schema name is AWR_STAGE.\nTo use this name, press &lt;return&gt; to continue, otherwise enter\nan alternative.\n\nEnter value for schema_name:\n\nUsing the staging schema name: AWR_STAGE\n\nChoose the Default tablespace for the AWR_STAGE user\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nChoose the AWR_STAGE users&#039;s default tablespace.  This is the\ntablespace in which the AWR data will be staged.\n\nTABLESPACE_NAME            CONTENTS          DEFAULT TABLESPACE\n------------------------------ --------------------- ------------------\nET_AC                  PERMANENT\nSYSAUX                 PERMANENT         *\nUSERS                  PERMANENT\n\nPressing &lt;return&gt; will result in the recommended default\ntablespace (identified by *) being used.\n\nEnter value for default_tablespace: ET_AC\n\nUsing tablespace ET_AC as the default tablespace for the AWR_STAGE\n\n\nChoose the Temporary tablespace for the AWR_STAGE user\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nChoose the AWR_STAGE user's temporary tablespace.\n\nTABLESPACE_NAME            CONTENTS          DEFAULT TEMP TABLESPACE\n------------------------------ --------------------- -----------------------\nET_TEMP                TEMPORARY\nTEMP                   TEMPORARY         *\n\nPressing &lt;return&gt; will result in the database's default temporary\ntablespace (identified by *) being used.\n\nEnter value for temporary_tablespace: TEMP\n\nUsing tablespace TEMP as the temporary tablespace for AWR_STAGE\n\n... Creating AWR_STAGE user\n\n|\n| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n|  Loading the AWR data from the following\n|  directory\/file:\n|   \/home\/oracle\/expawr\n|   awrexp_20210721.dmp.dmp\n| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n|\n|  *** AWR Load Started ...\n|\n|  This operation will take a few moments. The\n|  progress of the AWR load operation can be\n|  monitored in the following directory\/file:\n|   \/home\/oracle\/expawr\n|   awrexp_20210721.dmp.log\n|\n... Dropping AWR_STAGE user\n\nEnd of AWR Load\n<\/code><\/pre>\n<p><strong>schemas \u5c0f\u63d2\u66f2\uff1aschema\u540d\u79f0\u5fc5\u987b\u662foracle\u6570\u636e\u5e93\u4e2d\u4e0d\u5b58\u5728\u7684\uff0c\u4e0d\u7136\u4f1a\u5f02\u5e38\u9000\u51fa.<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"25_%E5%AF%B9%E5%AF%BC%E5%85%A5%E7%9A%84AWR%E5%BF%AB%E7%85%A7%E8%BF%9B%E8%A1%8C%E9%AA%8C%E8%AF%81\"><\/span>2.5. \u5bf9\u5bfc\u5165\u7684AWR\u5feb\u7167\u8fdb\u884c\u9a8c\u8bc1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql line-numbers\">SQL&gt;\nSELECT snap_id,dbid,instance_number,to_char(begin_interval_time,'yyyy-MM-dd hh24:mi:ss.ff')\n  FROM dba_hist_snapshot\n WHERE dbid= 1386205165\n ORDER BY 1,3;\n<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_c94d7c54397d0b536905e4b2f790a7ae.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_c94d7c54397d0b536905e4b2f790a7ae.jpg\" alt=\"\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \u5bfc\u51faAWR 1.1 \u521b\u5efa\u5bfc\u51fa\u6587\u4ef6\u76ee\u5f55 \u5207\u6362\u5230&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,21],"tags":[],"class_list":["post-301","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=301"}],"version-history":[{"count":4,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":305,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions\/305"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}