{"id":2121,"date":"2017-12-05T23:38:45","date_gmt":"2017-12-06T05:38:45","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2121"},"modified":"2026-02-07T15:34:40","modified_gmt":"2026-02-07T21:34:40","slug":"adaptive-query-performance-fixes-for-db12c-release-1","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2017\/2121\/","title":{"rendered":"Adaptive Query Performance Fixes for #DB12c Release 1"},"content":{"rendered":"<p>We all know adaptive query feature introduced in Oracle Database Release 1 is a problem. Recently I had the opportunity to review few 12cR1 databases and found that to alleviate the performance problems, the DBA set parameter OPTIMIZER_FEATURES_ENABLE=11.2.0.4 in Oracle Database 12c Release 1 (12.1.0.2). This observation is the catalyst for the blog &#8220;<a href=\"https:\/\/www.oneneck.com\/blog\/-oracle-database-12c-release-1\">Adaptive Query Patches in Oracle Database 12c Release 1<\/a>&#8221; on my Company Blog. \u00a0Oracle Support team provided options to turn off the new feature (OPTIMIZER_ADAPTIVE_FEATURES=FALSE) or to fix the issues with a Proactive Bundle Patch or with a one-off patch. Please read the blog to find out the options DBA have to fix the adaptive query optimization problem in Oracle Database 12c Release 1.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We all know adaptive query feature introduced in Oracle Database Release 1 is a problem. Recently I had the opportunity to review few 12cR1 databases and found that to alleviate the performance problems, the DBA set parameter OPTIMIZER_FEATURES_ENABLE=11.2.0.4 in Oracle Database 12c Release 1 (12.1.0.2). This observation is the catalyst for the blog &#8220;Adaptive Query &#8230; <a title=\"Adaptive Query Performance Fixes for #DB12c Release 1\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2017\/2121\/\" aria-label=\"Read more about Adaptive Query Performance Fixes for #DB12c Release 1\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[40,61],"class_list":["post-2121","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-oracle-12c","tag-performance"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2121"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2121\/revisions"}],"predecessor-version":[{"id":3010,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2121\/revisions\/3010"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}