{"id":71,"date":"2015-02-24T12:01:59","date_gmt":"2015-02-24T12:01:59","guid":{"rendered":"https:\/\/www.spotonoracle.com\/?p=71"},"modified":"2016-05-10T12:03:45","modified_gmt":"2016-05-10T12:03:45","slug":"explicit-default-securefile-parameter-change","status":"publish","type":"post","link":"https:\/\/www.spotonoracle.com\/?p=71","title":{"rendered":"Explicit Default &#8211; SecureFile parameter change"},"content":{"rendered":"<p>While introducing a new value for parameter DB_SECUREFILE in Oracle 12c the default value has changed as well (see <a title=\"doc\" href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e40402\/initparams068.htm#REFRN10290\" target=\"_blank\">doc<\/a>).<br \/>\nWith the new value &#8220;PREFERRED&#8221; all LOBs are created as SecureFile LOBs if not explicitly specified otherwise.<\/p>\n<p>Just out of curiosity I created two databases, one with default &#8220;PREFERRED&#8221; the other with &#8220;PERMITTED&#8221; as it was the default in 11g.<br \/>\nCheck out what happens to the Oracle data dictionary:<\/p>\n<p>DB_SECUREFILE = PREFERRED<\/p>\n<pre class=\"brush: sql; collapse: false; title: ; wrap-lines: false; notranslate\" title=\"\">\r\nSQL&gt; select owner, securefile, count(*) from dba_lobs group by owner, securefile order by owner;\r\nOWNER                 SECUREFILE CNT\r\n--------------------- ---------- ----------\r\nCTXSYS                YES        4\r\nGSMADMIN_INTERNAL     YES        1\r\nOJVMSYS               NO         1\r\nOUTLN                 NO         1\r\nSYS                   NO         120\r\nSYS                   YES        75\r\nSYSTEM                NO         21\r\nSYSTEM                YES        2\r\nWMSYS                 YES        8\r\nXDB                   NO         2\r\nXDB                   YES        291\r\n<\/pre>\n<p>DB_SECUREFILE = PERMITTED<\/p>\n<pre class=\"brush: sql; collapse: false; title: ; wrap-lines: false; notranslate\" title=\"\">\r\nSQL&gt; select owner, securefile, count(*) from dba_lobs group by owner, securefile order by owner;\r\nOWNER                 SECUREFILE CNT\r\n--------------------- ---------- ----------\r\nCTXSYS                NO         4\r\nGSMADMIN_INTERNAL     NO         1\r\nOJVMSYS               NO         1\r\nOUTLN                 NO         1\r\nSYS                   NO         194\r\nSYS                   YES        1\r\nSYSTEM                NO         23\r\nWMSYS                 NO         8\r\nXDB                   NO         286\r\nXDB                   YES        7\r\n<\/pre>\n<p>Quick thoughts:<\/p>\n<ol>\n<li>With every release study the New Features Guide carefully. Oracle&#8217;s not always waving a big red flag when &#8220;minor&#8221; things change.<\/li>\n<li>Do I like varying data dictionary definitions? No. I&#8217;m going to take great care when creating or migrating databases that they all look alike.<\/li>\n<li>What funny side effects we will encounter?<\/li>\n<li>I can see where Oracle is coming from, but if it is me I always try to be as explicit as possible and not relying on instance settings. When developing software and my customer base is, let&#8217;s say bigger than five I want to make sure all they&#8217;re schema deployments look the same.<\/li>\n<\/ol>\n<p>Foot note: All test have been run on Oracle 12.1.0.2<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While introducing a new value for parameter DB_SECUREFILE in Oracle 12c the default value has changed as well (see doc). With the new value &#8220;PREFERRED&#8221; all LOBs are created as SecureFile LOBs if not explicitly specified otherwise. Just out of curiosity I created two databases, one with default &#8220;PREFERRED&#8221; the other with &#8220;PERMITTED&#8221; as it [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-internals"],"_links":{"self":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":2,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":73,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/73"}],"wp:attachment":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}