{"id":1368,"date":"2018-01-13T14:12:57","date_gmt":"2018-01-13T06:12:57","guid":{"rendered":"http:\/\/www.821121.com\/?p=1368"},"modified":"2021-03-02T10:50:52","modified_gmt":"2021-03-02T02:50:52","slug":"asm%e5%ae%9e%e4%be%8b%e8%b0%83%e6%95%b4memory%e5%86%85%e5%ad%98%e5%8f%82%e6%95%b0","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1368","title":{"rendered":"ASM\u5b9e\u4f8b\u8c03\u6574memory\u5185\u5b58\u53c2\u6570"},"content":{"rendered":"<pre><code class=\"language-sql\">ASM\u8c03\u6574memory\u5185\u5b58\u53c2\u6570\u5c0f\u4e8e1G\u5931\u6548\uff0c\u6d4b\u8bd5\u73af\u5883\u5b89\u88c519c,\u5185\u5b58\u4e0d\u592a\u591f\uff0c\u9700\u8981\u964d\u4f4easm \u5185\u5b58\u53c2\u6570\uff0c\u4f46\u662f\u53d1\u73b0\u8c03\u6574\u540e\u672a\u751f\u6548.\u603b\u7ed3\u4e0b\uff0coracle 11.2.0.4 &gt;=oracle \u5efa\u8bae\u662fasm\u5185\u5b58\u662f\u6700\u4f4e1G\uff0c\u5982\u679c\u914d\u7f6e\u5c0f\u4e8e\u8fd9\u4e2a\u6570\u503c\uff0c\u4f1a\u81ea\u52a8\u8c03\u6574\u4e3a1G\u5927\u5c0f.\n<\/code><\/pre>\n<h1>1.\u67e5\u770b\u5f53\u524d\u7684memory<\/h1>\n<pre><code class=\"language-sql\">SQL&gt;show parameter memory\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nmemory_max_target                    big integer 1076M\nmemory_target                        big integer 1076M<\/code><\/pre>\n<h1>2.\u4fee\u6539memory\u53c2\u6570\uff0c\u5e76\u91cd\u542f\u67e5\u770b<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; alter system set memory_max_target=400m scope=spfile sid=&#039;+ASM1&#039;;\nSQL&gt; alter system set memory_target=400m scope=spfile sid=&#039;+ASM1&#039;;\n\n\u91cd\u542fASM\u5b9e\u4f8b\u540e,Memory_target\u53c2\u6570\u65e0\u53d8\u5316\uff0c\u4e14\u6570\u636e\u5e93\u672a\u62a5\u9519\u3002\n$ srvctl stop asm -n c1 -stopoption IMMEDIATE -force\n$ srvctl start asm -n c1\nSQL&gt;show parameter memory\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nmemory_max_target                    big integer 1076M\nmemory_target                        big integer 1076M\n\nSQL&gt; alter system set memory_max_target=400m scope=spfile sid=&#039;+ASM1&#039;;\nSQL&gt; alter system set memory_target=400m scope=spfile sid=&#039;+ASM1&#039;;<\/code><\/pre>\n<h1>3.\u67e5\u770b ASM alert\u542f\u52a8\u65e5\u5fd7<\/h1>\n<pre><code class=\"language-sql\">Using parameter settings in server-side spfile +OCR\/ora19c-cluster\/ASMPARAMETERFILE\/registry.253.1036510257\nSystem parameters with non-default values:\nlarge_pool_size = 12M\nmemory_target = 1G\nmemory_max_target = 1G\n\n2019-04-01T06:47:45.260548-07:00\nDomain name: user.slice\n2019-04-01T06:47:45.260604-07:00\nPer process system memlock (soft) limit = UNLIMITED\n2019-04-01T06:47:45.260658-07:00\nExpected per process system memlock (soft) limit to lock\ninstance MAX SHARED GLOBAL AREA (SGA) into memory: 1021M\n<\/code><\/pre>\n<h1>4.\u67e5\u770b\u5b98\u65b9\u6587\u6863Doc ID 1982132.1<\/h1>\n<pre><code class=\"language-sql\">\u603b\u7ed3\u4e0b\uff0coracle 11.2.0.4 &gt;=oracle \u5efa\u8bae\u662fasm\u5185\u5b58\u662f\u6700\u4f4e1G\uff0c\u5982\u679c\u914d\u7f6e\u5c0f\u4e8e\u8fd9\u4e2a\u6570\u503c\uff0c\u4f1a\u81ea\u52a8\u8c03\u6574\u4e3a1G\u5927\u5c0f\uff01\n\u4ee5\u6b64\u7c7b\u63a8oracle19c\u7684asm\u5185\u5b58\u6700\u4f4e\u4e5f\u4e3a1g\uff0c\u6b63\u5e38\u60c5\u51b5\u6211\u4eec\u8bbe\u7f6easm\u5185\u5b58\u4e3a2g\nDefault and Minimum MEMORY_TARGET &amp; MEMORY_MAX_TARGET Value for ASM 11.2.0.4 and Onwards (Doc ID 1982132.1)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ASM\u8c03\u6574memory\u5185\u5b58\u53c2\u6570\u5c0f\u4e8e1G\u5931\u6548\uff0c\u6d4b\u8bd5\u73af<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1368","post","type-post","status-publish","format-standard","hentry","category-oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1368"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1368\/revisions"}],"predecessor-version":[{"id":1369,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1368\/revisions\/1369"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1368"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}