When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes life interesting, I recently had the privilege to deploy a new Oracle environment on AIX for a customer.
AIX is not linux and some things work a bit different, but the installation of an Oracle database runs more or less smoothly.
Since according to Oracle best practices large pages should be used for the SGA, so we prepared 200 large pages with a size of 16M for the database. We could verify this with svmon utility <\/p>\n\n\n\n
svmon\n\nPageSize PoolSize inuse pgsp pin virtual\ns 4 KB - 812827 29012 228798 252287\nm 64 KB - 61455 202 14189 61743\nL 16 MB 200 0 0 200 0\nS 16 GB - 0 0 0 0\n<\/code><\/pre>\n\n\n\nSo we can see, that the 200 Pages are availabe but not in use, because at this point in time i don’t setup a database on the server. The next step was to create a Oracle 19c database with dbca in silent mode with all the necessary settings. In Oracle 19c the default setting for the init parameter USE_LARGE_PAGES=TRUE. That means if oracle find some large pages on the server it will use it and if not it will allocate the memory for the sga with normal pages.
So after the database was created i checked the alert.log of the database and see the following output<\/p>\n\n\n\n
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)\n2022-08-11T12:57:12.094226+02:00\n 4K Configured 0 0 NONE\n2022-08-11T12:57:12.096517+02:00\n 64K Configured 118 118 NONE --> PGA\n2022-08-11T12:57:12.099008+02:00\n 16M Configured 192 192 NONE --> SGA\n2022-08-11T12:57:12.101851+02:00\n 16G Configured 0 0 NONE\n2022-08-11T12:57:12.104649+02:00\n\n<\/code><\/pre>\n\n\n\nSo far so good. In the alert.log for the database i can see, that oracle has allocated 192 Large Pages for the SGA. To be really sure that everything is fine we check svmon again <\/p>\n\n\n\n
svmon\n\nPageSize PoolSize inuse pgsp pin virtual\ns 4 KB - 812827 29012 228798 252287\nm 64 KB - 61455 202 14189 61743\nL 16 MB 200 0 0 200 0\nS 16 GB - 0 0 0 0<\/code><\/pre>\n\n\n\nMhm… wait a moment. Oracle tell us, that it has allocated 192 16M Pages but the AIX tells us that all 200 Pages are still not in use. So who is right? Let’s do another check. We can change the Parameter USE_LARGE_PAGES from TRUE to ONLY. That means if oracle is not able to allocate large pages during startup the instance will fail. So we change the Parameter and reboot the database. If it comes up large pages were used and oracle is right and if we get an error during startup we know oracle can’t allocate some Large Pages and the svmon was right. (That was my oppinion, which was wrong \ud83d\ude41 )<\/p>\n\n\n\n
SQL> alter system set use_large_pages=only scope=spfile;\nSQL> startup force;<\/code><\/pre>\n\n\n\nThe database came up without issues, and the alert.log tells me that 192 Pages were allocated. So it must be good, because i set use_large_pages=only, the database can only start with large pages. Right? No unfortunately not. After some resarch on oracle support i finally found out, that this parameter is useless on AIX. The tricky part ist, that oracle tells you, that it has allocated the pages but that is not true. To allocate the 16M Pages for the database you have to set the following init.ora parameter<\/p>\n\n\n\n
SQL> alter system set lock_sga=true;\nSQL> startup force<\/code><\/pre>\n\n\n\nAfter setting the lock_sga parameter to true and restart the database you can see, that now also svmon shows that the pages are in use<\/p>\n\n\n\n
svmon\n \nPageSize PoolSize inuse pgsp pin virtual\ns 4 KB - 812827 29012 228798 252287\nm 64 KB - 61455 202 14189 61743\nL 16 MB 200 193 0 200 193\nS 16 GB - 0 0 0 0\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes life interesting, I recently had the privilege to deploy a new Oracle environment on AIX […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,42,59],"tags":[2630,2661,2662],"type_dbi":[],"class_list":["post-18442","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-operating-systems","category-oracle","tag-19c-2","tag-aix-2","tag-large_pages"],"acf":[],"yoast_head":"\n
Configure Oracle DB for using Large Pages on AIX - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configure Oracle DB for using Large Pages on AIX\" \/>\n<meta property=\"og:description\" content=\"When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes life interesting, I recently had the privilege to deploy a new Oracle environment on AIX […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-12T13:41:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-06T10:36:38+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Configure Oracle DB for using Large Pages on AIX\",\"datePublished\":\"2022-08-12T13:41:00+00:00\",\"dateModified\":\"2023-01-06T10:36:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/\"},\"wordCount\":502,\"commentCount\":0,\"keywords\":[\"19c\",\"AIX\",\"Large_Pages\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/\",\"name\":\"Configure Oracle DB for using Large Pages on AIX - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-08-12T13:41:00+00:00\",\"dateModified\":\"2023-01-06T10:36:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/configure-oracle-db-for-using-large-pages-on-aix\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configure Oracle DB for using Large Pages on AIX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Configure Oracle DB for using Large Pages on AIX - dbi Blog","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:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/","og_locale":"en_US","og_type":"article","og_title":"Configure Oracle DB for using Large Pages on AIX","og_description":"When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes life interesting, I recently had the privilege to deploy a new Oracle environment on AIX […]","og_url":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/","og_site_name":"dbi Blog","article_published_time":"2022-08-12T13:41:00+00:00","article_modified_time":"2023-01-06T10:36:38+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Configure Oracle DB for using Large Pages on AIX","datePublished":"2022-08-12T13:41:00+00:00","dateModified":"2023-01-06T10:36:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/"},"wordCount":502,"commentCount":0,"keywords":["19c","AIX","Large_Pages"],"articleSection":["Database Administration & Monitoring","Database management","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/","url":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/","name":"Configure Oracle DB for using Large Pages on AIX - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-08-12T13:41:00+00:00","dateModified":"2023-01-06T10:36:38+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/configure-oracle-db-for-using-large-pages-on-aix\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Configure Oracle DB for using Large Pages on AIX"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=18442"}],"version-history":[{"count":4,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18442\/revisions"}],"predecessor-version":[{"id":18448,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18442\/revisions\/18448"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=18442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=18442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=18442"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=18442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}