Finding Undocumented ( Hidden ) Parameter with their details

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

Also Read Related Links:

1: Undocumented ( Hidden ) Parameters in Oracle 11g

2: Finding Undocumented ( Hidden ) Parameter in your database

#hidden-parameters, #oracle-11g