{"id":199,"date":"2018-04-25T14:28:59","date_gmt":"2018-04-25T17:28:59","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=199"},"modified":"2018-04-25T14:28:59","modified_gmt":"2018-04-25T17:28:59","slug":"ora-02095-specified-initialization-parameter-cannot-be-modified","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/25\/ora-02095-specified-initialization-parameter-cannot-be-modified\/","title":{"rendered":"ORA-02095: specified initialization parameter cannot be modified"},"content":{"rendered":"<p><strong>OPTIMIZER_ADAPTIVE_FEATURES obsoleto no Oracle 12.2<\/strong><\/p>\n<p><span id=\"result_box\" class=\"\" lang=\"pt\"><span class=\"\">No Oracle 12.2, o par\u00e2metro OPTIMIZER_ADAPTIVE_FEATURES foi removido e substitu\u00eddo por dois novos par\u00e2metros<\/span><\/span><\/p>\n<ul>\n<li><span id=\"result_box\" class=\"\" lang=\"pt\"><span class=\"\"><strong>OPTIMIZER_ADAPTIVE_PLANS:<\/strong> Padr\u00e3o (TRUE).<\/span> Ativa \/ desativa planos adaptativos, poda de bitmap de transforma\u00e7\u00e3o de estrela e o m\u00e9todo de distribui\u00e7\u00e3o adaptativa paralela.<\/span><\/li>\n<li><span id=\"result_box\" class=\"\" lang=\"pt\"><strong>OPTIMIZER_ADAPTIVE_STATISTICS:<\/strong> Padr\u00e3o (FALSE). Ativa \/ desativa diretivas de plano de SQL, feedback de estat\u00edsticas para jun\u00e7\u00f5es, feedback de desempenho e amostragem din\u00e2mica adaptativa para execu\u00e7\u00e3o paralela.<\/span><\/li>\n<\/ul>\n<pre class=\"lang:plsql decode:true \">Altera\u00e7\u00e3o a n\u00edvel de sess\u00e3o\n\nALTER SESSION SET OPTIMIZER_ADAPTIVE_PLANS = FALSE;\nALTER SESSION SET OPTIMIZER_ADAPTIVE_PLANS = TRUE;\n\nALTER SESSION SET OPTIMIZER_ADAPTIVE_STATISTICS = TRUE;\nALTER SESSION SET OPTIMIZER_ADAPTIVE_STATISTICS = FALSE;<\/pre>\n<pre class=\"lang:plsql decode:true \">Altera\u00e7\u00e3o a n\u00edvel de sistema.\n\nALTER SYSTEM SET OPTIMIZER_ADAPTIVE_PLANS = FALSE SCOPE=BOTH;\nALTER SYSTEM SET OPTIMIZER_ADAPTIVE_PLANS = TRUE SCOPE=BOTH;\n\nALTER SYSTEM SET OPTIMIZER_ADAPTIVE_STATISTICS = TRUE SCOPE=BOTH;\nALTER SYSTEM SET OPTIMIZER_ADAPTIVE_STATISTICS = FALSE SCOPE=BOTH;<\/pre>\n<p>Consulta ap\u00b4os desabilitar.<\/p>\n<pre class=\"lang:plsql decode:true \">SQL &gt; show parameter OPTIMIZER_ADAPTIVE_PLANS\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\noptimizer_adaptive_plans             boolean     FALSE\n<\/pre>\n<pre class=\"lang:plsql decode:true \">SQL &gt; show parameter OPTIMIZER_ADAPTIVE_STATISTICS\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\noptimizer_adaptive_statistics        boolean     FALSE\n<\/pre>\n<p><a href=\"https:\/\/oracle-base.com\/articles\/12c\/adaptive-query-optimization-12cr1\" target=\"_blank\" rel=\"noopener\">Fonte: Oracle-Base<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OPTIMIZER_ADAPTIVE_FEATURES obsoleto no Oracle 12.2 No Oracle 12.2, o par\u00e2metro OPTIMIZER_ADAPTIVE_FEATURES foi removido e substitu\u00eddo por dois novos par\u00e2metros OPTIMIZER_ADAPTIVE_PLANS: Padr\u00e3o (TRUE). Ativa \/ desativa planos adaptativos, poda de bitmap de transforma\u00e7\u00e3o de estrela e o m\u00e9todo de distribui\u00e7\u00e3o adaptativa paralela. OPTIMIZER_ADAPTIVE_STATISTICS: Padr\u00e3o (FALSE). Ativa \/ desativa diretivas de plano de SQL, feedback de estat\u00edsticas&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[209,210,211,222,223],"class_list":["post-199","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-optimizer_adaptive_features","tag-optimizer_adaptive_plans","tag-optimizer_adaptive_statistics","tag-ora-02095","tag-ora-02095-specified-initialization-parameter-cannot-be-modified"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/199\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}