{"id":15932,"date":"2023-12-04T23:47:41","date_gmt":"2023-12-04T15:47:41","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=15932"},"modified":"2023-12-05T00:08:23","modified_gmt":"2023-12-04T16:08:23","slug":"oracle-zhong-ju-chu3zhong-ke-yi-shou-ji-three-advi","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/12\/04\/oracle-zhong-ju-chu3zhong-ke-yi-shou-ji-three-advi\/","title":{"rendered":"Oracle \u4e2d\u4e3e\u51fa3\u79cd\u53ef\u4ee5\u6536\u96c6 three advisory statistics\uff1f"},"content":{"rendered":"<p>\u5728 Oracle \u6570\u636e\u5e93\u4e2d\uff0cAdvisory Statistics\uff08\u5efa\u8bae\u6027\u7edf\u8ba1\uff09\u662f\u7528\u4e8e\u5e2e\u52a9\u6570\u636e\u5e93\u7ba1\u7406\u5458\u548c\u6027\u80fd\u8c03\u4f18\u4e13\u5bb6\u4e86\u89e3\u7cfb\u7edf\u6027\u80fd\u548c\u5065\u5eb7\u72b6\u51b5\u7684\u4e00\u7ec4\u7edf\u8ba1\u4fe1\u606f\u3002\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u53ef\u7528\u4e8e\u5236\u5b9a\u6027\u80fd\u4f18\u5316\u7b56\u7565\u3002\u4ee5\u4e0b\u662f\u4e09\u79cd\u53ef\u4ee5\u6536\u96c6\u7684 Advisory Statistics\uff1a<\/p>\n<ol>\n<li><strong>Buffer Cache Advisory\uff08\u7f13\u5b58\u533a\u7f13\u5b58\u5efa\u8bae\u6027\u7edf\u8ba1\uff09\uff1a<\/strong>\n<ul>\n<li>\u901a\u8fc7\u542f\u7528 Buffer Cache Advisory \u7edf\u8ba1\uff0c\u53ef\u4ee5\u6536\u96c6\u5173\u4e8e\u7f13\u5b58\u533a\u7f13\u5b58\u4f7f\u7528\u60c5\u51b5\u7684\u4fe1\u606f\u3002\u8fd9\u5305\u62ec\u7f13\u5b58\u533a\u7684\u547d\u4e2d\u7387\u3001\u7f13\u5b58\u533a\u7684\u5927\u5c0f\u3001\u63a8\u8350\u7684\u7f13\u5b58\u533a\u5927\u5c0f\u7b49\u3002<\/li>\n<li>\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u542f\u7528 Buffer Cache Advisory \u7edf\u8ba1\uff1a\n<pre><code class=\"language-sql  line-numbers\">ALTER SYSTEM SET STATISTICS_LEVEL = ALL;\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li><strong>Shared Pool Advisory\uff08\u5171\u4eab\u6c60\u5efa\u8bae\u6027\u7edf\u8ba1\uff09\uff1a<\/strong>\n<ul>\n<li>Shared Pool Advisory \u7edf\u8ba1\u63d0\u4f9b\u4e86\u6709\u5173\u5171\u4eab\u6c60\u4f7f\u7528\u60c5\u51b5\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u5171\u4eab\u6c60\u7684\u547d\u4e2d\u7387\u3001\u5171\u4eab\u6c60\u7684\u5927\u5c0f\u3001\u63a8\u8350\u7684\u5171\u4eab\u6c60\u5927\u5c0f\u7b49\u3002<\/li>\n<li>\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u542f\u7528 Shared Pool Advisory \u7edf\u8ba1\uff1a\n<pre><code class=\"language-sql  line-numbers\">ALTER SYSTEM SET STATISTICS_LEVEL = ALL;\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li><strong>PGA Target Advisory\uff08PGA \u76ee\u6807\u5efa\u8bae\u6027\u7edf\u8ba1\uff09\uff1a<\/strong>\n<ul>\n<li>PGA Target Advisory \u7edf\u8ba1\u63d0\u4f9b\u4e86\u6709\u5173 PGA \u5185\u5b58\u4f7f\u7528\u60c5\u51b5\u7684\u4fe1\u606f\uff0c\u5305\u62ec PGA \u7684\u547d\u4e2d\u7387\u3001PGA \u7684\u76ee\u6807\u5927\u5c0f\u3001\u63a8\u8350\u7684 PGA \u76ee\u6807\u5927\u5c0f\u7b49\u3002<\/li>\n<li>\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u542f\u7528 PGA Target Advisory \u7edf\u8ba1\uff1a\n<pre><code class=\"language-sql  line-numbers\">ALTER SYSTEM SET PGA_AGGREGATE_TARGET = value;\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>\u5728\u4e0a\u8ff0\u8bed\u53e5\u4e2d\uff0c\u5c06 <code>value<\/code> \u66ff\u6362\u4e3a\u5e0c\u671b\u4e3a\u76f8\u5e94\u7684 Advisory Statistics \u8bbe\u7f6e\u7684\u503c\u3002\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u5f00\u542f\u5efa\u8bae\u6027\u7edf\u8ba1\u53ef\u80fd\u4f1a\u5bf9\u7cfb\u7edf\u6027\u80fd\u4ea7\u751f\u4e00\u5b9a\u7684\u5f00\u9500\uff0c\u56e0\u6b64\u5728\u751f\u4ea7\u73af\u5883\u4e2d\u9700\u8981\u8c28\u614e\u4f7f\u7528\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728 Oracle \u6570\u636e\u5e93\u4e2d\uff0cAdvisory Statistics\uff08\u5efa\u8bae\u6027\u7edf\u8ba1\uff09\u662f\u7528\u4e8e\u5e2e\u52a9\u6570\u636e\u5e93\u7ba1\u7406\u5458\u548c\u6027\u80fd\u8c03 [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[120],"tags":[],"class_list":["post-15932","post","type-post","status-publish","format-standard","hentry","category-oracel"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/15932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/comments?post=15932"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/15932\/revisions"}],"predecessor-version":[{"id":15933,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/15932\/revisions\/15933"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=15932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=15932"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=15932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}