Finding Undocumented ( Hidden ) Parameter with their details :
Below given script will provide you, the list of all the Undocumented ( Hidden ) initialization parameters present in your database along with their default values and descriptions.
REM FILE: HIDDEN_PARAMETERS.SQL
REM DESC: SEE UNDERSCORE '_' HIDDEN DB PARAMETERS
SET PAUSE ON
SET PAUSE 'PRESS RETURN TO CONTINUE'
SET PAGESIZE 400
SET LINESIZE 300
COLUMN Param FORMAT a42 wrap head 'Underscore Parameter'
COLUMN Descr FORMAT a75 wrap head 'Description'
COLUMN SessionVal FORMAT a7 head 'Value|Session'
COLUMN InstanceVal FORMAT a7 head 'Value|Instnc'
ttitle skip 1 center 'All Underscore Parameters' skip 2
SELECT
a.ksppinm Param ,
b.ksppstvl SessionVal ,
c.ksppstvl InstanceVal,
a.ksppdesc Descr
FROM
x$ksppi a ,
x$ksppcv b ,
x$ksppsv c
WHERE
a.indx = b.indx AND
a.indx = c.indx AND
a.ksppinm LIKE '/_%' escape '/'
ORDER BY
1
/click on hidden parameters to see the list of all Undocumented ( Hidden ) initialization parameters with their default value and description.
Password: airydba@123
Thank you for reading… This is Airy…Enjoy 🙂