{"id":1214,"date":"2018-02-26T10:56:36","date_gmt":"2018-02-26T02:56:36","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1214"},"modified":"2019-01-17T11:05:59","modified_gmt":"2019-01-17T03:05:59","slug":"oracle-%e7%94%9f%e6%88%90awr%e5%88%86%e6%9e%90%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1214","title":{"rendered":"Oracle \u751f\u6210AWR\u5206\u6790\u6587\u4ef6"},"content":{"rendered":"

\n\t\u901a\u8fc7\u6570\u636e\u5e93\u7528\u6237\uff1a\n<\/p>\n

\n\tcd $ORACLE_HOME\/rdbms\/admin\n<\/p>\n

\n\t@$ORACLE_HOME\/rdbms\/admin\/awrrpt.sql
\n\tSQL> @awrrpt.sql\n<\/p>\n

\n\t\u8f93\u5165\u76f8\u5e94\u7684\u53c2\u6570\u5373\u53ef\u5728admin\u76ee\u5f55\u4e0b\u627e\u5230\u751f\u6210\u7684\u6587\u4ef6\u3002\n<\/p>\n

\n\t\u8bf4\u660e\uff1a\u8fdb\u5165sqlplus\u524d\u7684\u76ee\u5f55\uff0c\u4e00\u5b9a\u8981\u662f\u6570\u636e\u5e93\u7528\u6237\u80fd\u591f\u6709\u6743\u9650\u5199\u5165\u6587\u4ef6\u7684\u76ee\u5f55\u3002\n<\/p>\n

\n\t \n<\/p>\n

\n\t\u53c2\u8003\uff1a\n<\/p>\n

\n\t–\u5982\u4f55\u5206\u6790Oracle_AWR\u62a5\u544a
\n\t\n<\/p>\n

\n\thttps:\/\/blog.csdn.net\/heqiyu34\/article\/details\/52981580\n<\/p>\n

\n\thttps:\/\/blog.csdn.net\/zq9017197\/article\/details\/7345352\n<\/p>\n

\n\t–awr\u591a\u4e2a\u5b9e\u4f8b\u540d\u7684\u60c5\u51b5\u5904\u7406\n<\/p>\n

\n\thttps:\/\/www.cnblogs.com\/kerrycode\/archive\/2016\/07\/18\/5681816.html\n<\/p>\n

\n\t–\u5229\u7528addmrpt.sql\n<\/p>\n

\n\thttps:\/\/blog.csdn.net\/leshami\/article\/details\/70859672\n<\/p>\n

\n\t–\u503c\u5f97\u53c2\u8003\n<\/p>\n

\n\thttps:\/\/blog.csdn.net\/shipeng1022\/article\/details\/52094355\n<\/p>\n

\n\t \n<\/p>\n

\n\t \n<\/p>\n

\n\t