{"id":116,"date":"2015-04-02T11:07:13","date_gmt":"2015-04-02T09:07:13","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=116"},"modified":"2015-11-17T20:27:22","modified_gmt":"2015-11-17T19:27:22","slug":"oracle-12-1-0-2-ora-600-qerhjdisablehjcbk-not-a-hash-join-on-update","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2015\/04\/02\/oracle-12-1-0-2-ora-600-qerhjdisablehjcbk-not-a-hash-join-on-update\/","title":{"rendered":"Oracle 12.1.0.2 &#8211; ORA-600 [QERHJDISABLEHJCBK: NOT A HASH JOIN] on UPDATE"},"content":{"rendered":"<p>Surprises happen when you go to the latest version of Oracle without deep testing.<br \/>\nMy client just hit the bug:<br \/>\nBug 20513930 : UPDATE FAILS WITH [QERHJDISABLEHJCBK: NOT A HASH JOIN]<\/p>\n<p>Basically the client was getting a ORA-600 [QERHJDISABLEHJCBK: NOT A HASH JOIN] when doing a certain query. Looking at it, it was an UPDATE of a view. This view had a &#8220;instead of update&#8221; trigger, which was doing several actions. After enabling trace on the session, the bug does not happen! <\/p>\n<p>Fortunately someone had already open the bug at Metalink. The workaround is to disable the new &#8220;groundbreaking feature&#8221; (dixit Oracle) called Adaptive Plans. <\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSQL&gt; alter system set &quot;_optimizer_adaptive_plans&quot;=false;\r\nSystem altered.\r\n<\/pre>\n<p>Hopefully there will be soon a patch for this problem.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Surprises happen when you go to the latest version of Oracle without deep testing. My client just hit the bug: Bug 20513930 : UPDATE FAILS WITH [QERHJDISABLEHJCBK: NOT A HASH JOIN] Basically the client was getting a ORA-600 [QERHJDISABLEHJCBK: NOT A HASH JOIN] when doing a certain query. Looking at it, it was an UPDATE [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6,7],"tags":[],"class_list":["post-116","post","type-post","status-publish","format-standard","category-bug","category-oracle","category-oracle-12c","czr-hentry"],"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":117,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/116\/revisions\/117"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}