{"id":395,"date":"2023-05-24T10:41:32","date_gmt":"2023-05-24T08:41:32","guid":{"rendered":"https:\/\/ptdb.ch\/?p=395"},"modified":"2023-05-24T10:41:32","modified_gmt":"2023-05-24T08:41:32","slug":"oracle-how-to-change-the-oracle-21c-asm-instance-from-memory_target-to-sga_target-use-hugepages","status":"publish","type":"post","link":"https:\/\/ptdb.ch\/?p=395","title":{"rendered":"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)"},"content":{"rendered":"<p>First of all, why do we want do change the memory settings for the ASM instance at all? There are many reasons why you might want to do it. The main reasons are that HugePages cannot be swapped, and the relief of TLB (Translation Lookaside Buffer) pressure, meaning that HugePages uses fewer pages to cover the physical address space, so the size of \u201cbook keeping\u201d (mapping from the virtual to the physical address) decreases, so it requiring fewer entries in the TLB.<br \/>\nAnother reason is, that you don&#8217;t want to mix different memory allocation techniques on your system. E.g. if your databases are already using HugePages, then ASM should do it also. In case you want to learn more about HugePages, check out the following MOS Note.<\/p>\n<p>Oracle Linux: HugePages What It Is&#8230; and What It Is Not&#8230; (Doc ID 361323.1)<\/p>\n<p>To implement HugePages for your ASM Instance, just do the following steps:<\/p>\n<ul>\n<li>Disable Transparent Hugepages first (if not already done)<\/li>\n<li>Implement Huge Pages on the OS Level (if not already done)<\/li>\n<li>Remove all the __shared_pool_size parameters and recreate the ASM spfile<\/li>\n<li>Set the parameters sga_max_size, sga_target and use_large_pages<\/li>\n<li>Restart HAS<\/li>\n<\/ul>\n<p>On my system, the memory target defaulted to about 1GB. It might be different on your system. So let&#8217;s get started and change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET.<\/p>\n<h4>Disable Transparent HugePages first<\/h4>\n<p>There is a quite good documentation of how to disable the Transparent HugePages features. The Transparent HugePages is something we do not want.<\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/ladbi\/disabling-transparent-hugepages.html\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/ladbi\/disabling-transparent-hugepages.html<\/a><\/p>\n<p>To check if the Transparent HugePages feature is really disabled, run the following command.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# cat \/sys\/kernel\/mm\/transparent_hugepage\/enabled\nalways madvise &#x5B;never]\n<\/pre>\n<h4>Implement HugePages on the OS Level<\/h4>\n<p>Now implement the HugePages if not already done.<\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/en\/operating-systems\/oracle-linux\/8\/osmanage\/osmanage-ConfiguringHugePages.html#osmanage_ConfiguringHugePages\">https:\/\/docs.oracle.com\/en\/operating-systems\/oracle-linux\/8\/osmanage\/osmanage-ConfiguringHugePages.html#osmanage_ConfiguringHugePages<\/a><\/p>\n<p>To check if HugePages are configured, run the following command.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# sysctl -a | grep -i huge\nvm.hugetlb_shm_group = 54321\nvm.nr_hugepages = 6144\nvm.nr_hugepages_mempolicy = 6144\nvm.nr_overcommit_hugepages = 0\n<\/pre>\n<h4>Remove all the __shared_pool_size parameters and recreate the ASM spfile<\/h4>\n<p>This is an optional step, and it is only required if you have some &#8220;double underscore values&#8221; in your parameter file.<\/p>\n<h4>Check the current values and do a copy of your spfile settings.<\/h4>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; create pfile='\/u01\/app\/oracle\/admin\/+ASM\/pfile\/init+ASM.ora.20230524a' from spfile;\n\nFile created.\n\nSQL&gt;\n\n$ cat \/u01\/app\/oracle\/admin\/+ASM\/pfile\/init+ASM.ora.20230524a\n+ASM.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from in memory value\n+ASM.asm_diskgroups='FRA','ACFS'#Manual Mount\n*.asm_diskstring='\/dev\/sd*','\/dev\/nvme0*'\n*.asm_power_limit=1\n*.large_pool_size=12M\n*.remote_login_passwordfile='EXCLUSIVE'\n\nSQL&gt; select NAME,BYTES from  v$sgainfo ;\n\nNAME                                  BYTES\n-------------------------------- ----------\nFixed SGA Size                      9456600\nASM Cache Size                     25165824\nShared Pool Size                  620756992\nLarge Pool Size                    12582912\nGranule Size                        4194304\nMaximum SGA Size                 1137724376\nStartup overhead in Shared Pool   190917512\nFree SGA Memory Available         469762048\n\n8 rows selected.\n\nSQL&gt; show sga\n\nTotal System Global Area 1137724376 bytes\nFixed Size                  9456600 bytes\nVariable Size            1103101952 bytes\nASM Cache                  25165824 bytes\nSQL&gt; show parameter memory\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nmemory_max_target                    big integer 1076M\nmemory_target                        big integer 1076M\nSQL&gt; show parameter sga\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nallow_group_access_to_sga            boolean     FALSE\nlock_sga                             boolean     FALSE\nsga_max_size                         big integer 1088M\nsga_target                           big integer 0\nSQL&gt;\n<\/pre>\n<h4>Change the parameters<\/h4>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; alter system reset memory_max_target scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; alter system reset memory_target scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; alter system set memory_max_target=0 scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; alter system set memory_target=0 scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; alter system set sga_max_size=2048M scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; alter system set sga_target=2048M scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; alter system set use_large_pages='ONLY' scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt;\n\n\nSQL&gt; create pfile='\/u01\/app\/oracle\/admin\/+ASM\/pfile\/init+ASM.ora.20230524b' from spfile;\n\nFile created.\n\nSQL&gt;\n\n$ cat \/u01\/app\/oracle\/admin\/+ASM\/pfile\/init+ASM.ora.20230524b\n+ASM.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from in memory value\n+ASM.asm_diskgroups='FRA','ACFS'#Manual Mount\n*.asm_diskstring='\/dev\/sd*','\/dev\/nvme0*'\n*.asm_power_limit=1\n*.large_pool_size=12M\n*.memory_max_target=0\n*.memory_target=0\n*.remote_login_passwordfile='EXCLUSIVE'\n*.sga_max_size=2147483648\n*.sga_target=2147483648\n*.use_large_pages='ONLY'\n<\/pre>\n<h4>Restart HAS (High Availability Services)<\/h4>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ crsctl stop has\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ocm199'\nCRS-2673: Attempting to stop 'ora.evmd' on 'ocm199'\nCRS-2673: Attempting to stop 'ora.ACFS.dg' on 'ocm199'\nCRS-2673: Attempting to stop 'ora.cdb.db' on 'ocm199'\nCRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ocm199'\nCRS-2677: Stop of 'ora.ACFS.dg' on 'ocm199' succeeded\nCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ocm199' succeeded\nCRS-2677: Stop of 'ora.evmd' on 'ocm199' succeeded\nCRS-2677: Stop of 'ora.cdb.db' on 'ocm199' succeeded\nCRS-2673: Attempting to stop 'ora.DATA.dg' on 'ocm199'\nCRS-2673: Attempting to stop 'ora.FRA.dg' on 'ocm199'\nCRS-2677: Stop of 'ora.FRA.dg' on 'ocm199' succeeded\nCRS-2677: Stop of 'ora.DATA.dg' on 'ocm199' succeeded\nCRS-2673: Attempting to stop 'ora.asm' on 'ocm199'\nCRS-2677: Stop of 'ora.asm' on 'ocm199' succeeded\nCRS-2673: Attempting to stop 'ora.cssd' on 'ocm199'\nCRS-2677: Stop of 'ora.cssd' on 'ocm199' succeeded\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ocm199' has completed\nCRS-4133: Oracle High Availability Services has been stopped.\n\n$ crsctl start has\nCRS-4123: Oracle High Availability Services has been started.\n<\/pre>\n<h4>Check the alert.log if everything is ok.<\/h4>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nStarting ORACLE instance (normal) (OS id: 4283)\n2023-05-24T08:40:22.477100+02:00\n************************************************************\nInstance SGA_TARGET = 2048 MB and SGA_MAX_SIZE = 2048 MB\n************************************************************\n2023-05-24T08:40:22.477209+02:00\n****************************************************\n Sys-V shared memory will be used for creating SGA\n ****************************************************\n2023-05-24T08:40:22.477644+02:00\n**********************************************************************\n2023-05-24T08:40:22.477672+02:00\nDump of system resources acquired for SHARED GLOBAL AREA (SGA)\n\n2023-05-24T08:40:22.477720+02:00\n Domain name: system.slice\/ohasd.service\n2023-05-24T08:40:22.477746+02:00\n Per process system memlock (soft) limit = 128G\n2023-05-24T08:40:22.477772+02:00\n Expected per process system memlock (soft) limit to lock\n instance MAX SHARED GLOBAL AREA (SGA) into memory: 2044M\n2023-05-24T08:40:22.477820+02:00\n Available system pagesizes:\n  4K, 2048K\n2023-05-24T08:40:22.477867+02:00\n Supported system pagesize(s):\n2023-05-24T08:40:22.477892+02:00\n  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)\n2023-05-24T08:40:22.477942+02:00\n     2048K             6144            1022             1022        NONE\n2023-05-24T08:40:22.477966+02:00\n...\n...\nUsing parameter settings in server-side spfile +DATA\/ASM\/ASMPARAMETERFILE\/registry.253.1135337751\nSystem parameters with non-default values:\n  sga_max_size             = 2G\n  use_large_pages          = &quot;ONLY&quot;\n  large_pool_size          = 16M\n  sga_target               = 2G\n  memory_target            = 0\n  memory_max_target        = 0\n  remote_login_passwordfile= &quot;EXCLUSIVE&quot;\n  asm_diskstring           = &quot;\/dev\/sd*&quot;\n  asm_diskstring           = &quot;\/dev\/nvme0*&quot;\n  asm_diskgroups           = &quot;FRA&quot;\n  asm_diskgroups           = &quot;ACFS&quot;\n  asm_power_limit          = 1\n...\n...\n<\/pre>\n<h4>Check the \/proc\/meminfo and ipcs output to see if the HugePages are really used.<\/h4>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ cat \/proc\/meminfo | grep -i huge\nAnonHugePages:         0 kB\nShmemHugePages:        0 kB\nFileHugePages:         0 kB\nHugePages_Total:    6144\nHugePages_Free:     3024\nHugePages_Rsvd:        0\nHugePages_Surp:        0\nHugepagesize:       2048 kB\nHugetlb:        12582912 kB\n\n$ ipcs --shmems\n\n------ Shared Memory Segments --------\nkey        shmid      owner      perms      bytes      nattch     status\n0x00000000 2          grid       600        10485760   31\n0x00000000 3          grid       600        2130706432 31\n0x73a656dc 4          grid       600        2097152    31\n<\/pre>\n<h4>Ready. We have implemented HugePages for the ASM instance. \ud83d\ude42<\/h4>\n<p>In case you want to learn more about ASM and Huge Pages, check out the following MOS Notes.<\/p>\n<ul>\n<li>Oracle Linux: HugePages What It Is&#8230; and What It Is Not&#8230; (Doc ID 361323.1)<\/li>\n<li>Oracle Linux: HugePages on Oracle Linux 64-bit (Doc ID 361468.1)<\/li>\n<li>HugePages and Oracle Database Automatic Memory Management (AMM) on Linux (Doc ID 749851.1)<\/li>\n<li>Oracle Linux: Shell Script to Calculate Values Recommended Linux HugePages \/ HugeTLB Configuration (Doc ID 401749.1)<\/li>\n<li>Default and Minimum MEMORY_TARGET &amp; MEMORY_MAX_TARGET Value for ASM 11.2.0.4 and Onwards (Doc ID 1982132.1)<\/li>\n<li>ASM &amp; Shared Pool (ORA-4031) (Doc ID 437924.1)<\/li>\n<\/ul>\n<h3>Conclusion<\/h3>\n<p>Implementing HugePages for you ASM instance is not so complicated, and it really makes sense if you already use it for your Oracle database instances anyway.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First of all, why do we want do change the memory settings for the ASM instance at all? There are many reasons why you might want to do it. The main reasons are that HugePages cannot be swapped, and the relief of TLB (Translation Lookaside Buffer) pressure, meaning that HugePages uses fewer pages to cover [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"0","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[2,4],"tags":[14,18],"class_list":["post-395","post","type-post","status-publish","format-standard","hentry","category-db","category-oracle","tag-asm","tag-oracle","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages) - ptdb - Platinum DB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ptdb.ch\/?p=395\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages) - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"First of all, why do we want do change the memory settings for the ASM instance at all? There are many reasons why you might want to do it. The main reasons are that HugePages cannot be swapped, and the relief of TLB (Translation Lookaside Buffer) pressure, meaning that HugePages uses fewer pages to cover [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=395\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-24T08:41:32+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=395#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=395\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#\\\/schema\\\/person\\\/0b7baf52d23e71d85e1c95442306090b\"},\"headline\":\"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)\",\"datePublished\":\"2023-05-24T08:41:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=395\"},\"wordCount\":1374,\"keywords\":[\"ASM\",\"Oracle\"],\"articleSection\":[\"DB\",\"Oracle\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=395\",\"url\":\"https:\\\/\\\/ptdb.ch\\\/?p=395\",\"name\":\"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages) - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#website\"},\"datePublished\":\"2023-05-24T08:41:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#\\\/schema\\\/person\\\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=395#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ptdb.ch\\\/?p=395\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=395#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ptdb.ch\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#website\",\"url\":\"https:\\\/\\\/ptdb.ch\\\/\",\"name\":\"ptdb - Platinum DB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ptdb.ch\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#\\\/schema\\\/person\\\/0b7baf52d23e71d85e1c95442306090b\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/ptdb.ch\"],\"url\":\"https:\\\/\\\/ptdb.ch\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages) - ptdb - Platinum DB","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:\/\/ptdb.ch\/?p=395","og_locale":"en_US","og_type":"article","og_title":"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages) - ptdb - Platinum DB","og_description":"First of all, why do we want do change the memory settings for the ASM instance at all? There are many reasons why you might want to do it. The main reasons are that HugePages cannot be swapped, and the relief of TLB (Translation Lookaside Buffer) pressure, meaning that HugePages uses fewer pages to cover [&hellip;]","og_url":"https:\/\/ptdb.ch\/?p=395","og_site_name":"ptdb - Platinum DB","article_published_time":"2023-05-24T08:41:32+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ptdb.ch\/?p=395#article","isPartOf":{"@id":"https:\/\/ptdb.ch\/?p=395"},"author":{"name":"admin","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"headline":"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)","datePublished":"2023-05-24T08:41:32+00:00","mainEntityOfPage":{"@id":"https:\/\/ptdb.ch\/?p=395"},"wordCount":1374,"keywords":["ASM","Oracle"],"articleSection":["DB","Oracle"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=395","url":"https:\/\/ptdb.ch\/?p=395","name":"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages) - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"datePublished":"2023-05-24T08:41:32+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=395#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=395"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=395#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)"}]},{"@type":"WebSite","@id":"https:\/\/ptdb.ch\/#website","url":"https:\/\/ptdb.ch\/","name":"ptdb - Platinum DB","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ptdb.ch\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/ptdb.ch"],"url":"https:\/\/ptdb.ch\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=395"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}