HOw to find out list of Hidden parameters in oracle.


SET LINESIZE 145


SET PAGESIZE 9999

SET VERIFY off

COLUMN ksppinm FORMAT A42 HEAD 'Parameter Name'

COLUMN ksppstvl FORMAT A39 HEAD 'Value'

COLUMN ksppdesc FORMAT A60 HEAD 'Description' TRUNC

SELECT

ksppinm

, ksppstvl

, ksppdesc

FROM

x$ksppi x

, x$ksppcv y

WHERE

x.indx = y.indx

AND TRANSLATE(ksppinm,'_','#') like '#%'

/