{"id":11309,"date":"2019-04-12T06:25:43","date_gmt":"2019-04-12T06:25:43","guid":{"rendered":"https:\/\/dbtut.com\/?p=11309"},"modified":"2019-04-12T06:25:44","modified_gmt":"2019-04-12T06:25:44","slug":"configure-automatic-shared-memory-management-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/","title":{"rendered":"Configure Automatic Shared Memory Management in Oracle"},"content":{"rendered":"

To learn the Automatic Shared Memory Management, read the article titled “Oracle Memory Components(SGA and PGA)<\/a>“.<\/p>\n

For databases that do not use Automatic Shared Memory Management, ASMM(Automatic Shared Memory Management) configuration can be performed later. To perform this, it is necessary to change the required parameters and restart the database.<\/p>\n

To use the huge page on the database side, ASMM or manual memory management is required. The Huge page will not be available when Automatic Memory Management is active.<\/p>\n

Parameter Change<\/h2>\n

If Automatic Memory Management is used in the database, reset the memory_max_target and memory_target parameters as follows.<\/p>\n

SQL> alter system reset memory_max_target scope=spfile  sid='*';\n\nSystem altered.\n\nSQL> alter system reset memory_target  scope=spfile  sid='*';\n\nSystem altered.<\/pre>\n
Configure ASMM<\/h2>\n
You can set the necessary parameters for ASMM as follows.<\/p>\n
SQL> ALTER SYSTEM SET PGA_AGGREGATE_TARGET=5G SCOPE=SPFILE SID='*';\n\nSystem altered.\n\nSQL> ALTER SYSTEM SET SGA_TARGET=20G SCOPE=SPFILE SID='*';\n\nSystem altered.\n\nSQL> ALTER SYSTEM SET SGA_MAX_SIZE=20G SCOPE=SPFILE SID='*';\n\nSystem altered.<\/pre>\n
When changing parameters in RAC systems, sid = ‘*’ must be added to the end.<\/p>\n
The database needs to be restarted after you change the parameter.<\/p>\n
srvctl stop database -d ORCL\n\nsrvctl start database -d ORCL<\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
To learn the Automatic Shared Memory Management, read the article titled “Oracle Memory Components(SGA and PGA)“. For databases that do not use Automatic Shared Memory Management, ASMM(Automatic Shared Memory Management) configuration can be performed later. To perform this, it is necessary to change the required parameters and restart the database. To use the huge page …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":11310,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[3085,3089,3084,3082,3090,3083,3087,3088,3086,3093,3091,3092],"class_list":["post-11309","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-configure-asmm","tag-enable-automatic-shared-memory-management","tag-how-to-check-if-automatic-memory-management-is-enabled","tag-how-to-enable-automatic-memory-management-in-oracle","tag-huge-page-and-automatic-memory-management","tag-oracle-12c-automatic-memory-management","tag-reset-amm","tag-reset-asmm","tag-reset-automatic-memory-management","tag-what-is-asmm-in-oracle","tag-what-is-automatic-memory-management-in-oracle","tag-what-is-automatic-memory-management"],"aioseo_notices":[],"yoast_head":"\nConfigure Automatic Shared Memory Management in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Configure Automatic Shared Memory Management in Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configure Automatic Shared Memory Management in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Configure Automatic Shared Memory Management in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-12T06:25:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-12T06:25:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"497\" \/>\n\t<meta property=\"og:image:height\" content=\"258\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Configure Automatic Shared Memory Management in Oracle\",\"datePublished\":\"2019-04-12T06:25:43+00:00\",\"dateModified\":\"2019-04-12T06:25:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\"},\"wordCount\":151,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png\",\"keywords\":[\"Configure ASMM\",\"enable automatic shared memory management\",\"how to check if automatic memory management is enabled\",\"how to enable automatic memory management in oracle\",\"huge page and automatic memory management\",\"oracle 12c automatic memory management\",\"reset AMM\",\"reset ASMM\",\"reset automatic memory management\",\"What is ASMM in Oracle?\",\"What is automatic memory management in Oracle?\",\"What is automatic memory management?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\",\"name\":\"Configure Automatic Shared Memory Management in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png\",\"datePublished\":\"2019-04-12T06:25:43+00:00\",\"dateModified\":\"2019-04-12T06:25:44+00:00\",\"description\":\"Configure Automatic Shared Memory Management in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png\",\"width\":497,\"height\":258},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configure Automatic Shared Memory Management in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configure Automatic Shared Memory Management in Oracle - Database Tutorials","description":"Configure Automatic Shared Memory Management in Oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Configure Automatic Shared Memory Management in Oracle - Database Tutorials","og_description":"Configure Automatic Shared Memory Management in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-12T06:25:43+00:00","article_modified_time":"2019-04-12T06:25:44+00:00","og_image":[{"width":497,"height":258,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Configure Automatic Shared Memory Management in Oracle","datePublished":"2019-04-12T06:25:43+00:00","dateModified":"2019-04-12T06:25:44+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/"},"wordCount":151,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png","keywords":["Configure ASMM","enable automatic shared memory management","how to check if automatic memory management is enabled","how to enable automatic memory management in oracle","huge page and automatic memory management","oracle 12c automatic memory management","reset AMM","reset ASMM","reset automatic memory management","What is ASMM in Oracle?","What is automatic memory management in Oracle?","What is automatic memory management?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/","name":"Configure Automatic Shared Memory Management in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png","datePublished":"2019-04-12T06:25:43+00:00","dateModified":"2019-04-12T06:25:44+00:00","description":"Configure Automatic Shared Memory Management in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-11.png","width":497,"height":258},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/12\/configure-automatic-shared-memory-management-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Configure Automatic Shared Memory Management in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11309"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11309\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11310"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}