{"id":4,"date":"2006-07-19T00:57:00","date_gmt":"2006-07-19T04:57:00","guid":{"rendered":"http:\/\/www.benh.org\/techie\/2006\/07\/how-to-get-the-list-of-all-hidden-oracle-parameters\/"},"modified":"2010-08-27T03:04:10","modified_gmt":"2010-08-27T08:04:10","slug":"oracle-hidden-parameters","status":"publish","type":"post","link":"https:\/\/www.benh.org\/techblog\/2006\/07\/oracle-hidden-parameters\/","title":{"rendered":"Oracle Hidden Parameters"},"content":{"rendered":"<div style=\"margin-top: 0px; margin-bottom: 0px;\" class=\"sharethis-inline-share-buttons\" ><\/div><p><!--adsense#ads--><br \/>\nOracle initialization or INIT.ORA parameters with an underscore in front are hidden or unsupported parameters.  One can get a list of all hidden parameters by executing this query:<\/p>\n<p><code><\/p>\n<pre class=\"brush:sql\">SELECT *\r\n  FROM SYS.x$ksppi\r\n WHERE SUBSTR (ksppinm, 1, 1) = '_';<\/pre>\n<p><\/code><\/p>\n<p>The following query displays parameter names with their current value:<\/p>\n<p><code><\/p>\n<pre class=\"brush:sql\">\r\nSELECT   a.ksppinm \"Parameter\", b.ksppstvl \"Session Value\",\r\n         c.ksppstvl \"Instance Value\"\r\n    FROM x$ksppi a, x$ksppcv b, x$ksppsv c\r\n   WHERE a.indx = b.indx AND a.indx = c.indx AND SUBSTR (ksppinm, 1, 1) = '_'\r\nORDER BY a.ksppinm;<\/pre>\n<p><\/code><\/p>\n<p><span style=\"text-decoration: underline;\">Remember<\/span>: Thou shall not play with undocumented parameters! Using undocumented parameters without the consent of Oracle Support will make your database &#8220;un-supported&#8221;. You will be on your own if the parameters you&#8217;ve set cause problems or data corruption.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle initialization or INIT.ORA parameters with an underscore in front are hidden or unsupported parameters. One can get a list of all hidden parameters by executing this query: SELECT * FROM SYS.x$ksppi WHERE SUBSTR (ksppinm, 1, 1) = &#8216;_&#8217;; The following query displays parameter names with their current value: SELECT a.ksppinm &#8220;Parameter&#8221;, b.ksppstvl &#8220;Session Value&#8221;, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[63,41],"class_list":["post-4","post","type-post","status-publish","format-standard","hentry","category-database","tag-dba","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts\/4","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/comments?post=4"}],"version-history":[{"count":6,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts\/4\/revisions"}],"predecessor-version":[{"id":177,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts\/4\/revisions\/177"}],"wp:attachment":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/media?parent=4"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/categories?post=4"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/tags?post=4"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}