web analytics

Show hidden parameters in Oracle

Check the hidden underscore parameters

col "Parameter" FOR a50
col "Session Value" FOR a15
col "Instance Value" FOR a15

SELECT a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx AND a.indx = c.indx
AND SUBSTR(ksppinm,1,1)='_'
AND LOWER(a.ksppinm) LIKE LOWER('%&param%')
ORDER BY a.ksppinm;

Setting the parameter:

ALTER SYSTEM SET "&param." = VALUE scope = &scope. ;

scope is one of the following: “both”, “memory”, “spfile”

To remove completely the hidden parameter from the spfile:

ALTER SYSTEM reset "&param." scope=spfile SID='*';

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>




This site uses Akismet to reduce spam. Learn how your comment data is processed.


A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.