Finding the Hidden INIT.ORA Parameters in Oracle 10.2.0.5

Oracle contain INIT.ORA parameters that control how the database is configured and operates. These are the 'boot up' parameters for the database although so of them can be modified while the database is running.

A standard caution applies -- DO NOT USE ANY OF THESE parameters without permission from Oracle Support.

This query will display all 1360 hidden INIT.ORA parameters in Oracle 10.2.0.5. (you must be logged in as SYS to perform this query):

SELECT X.KSPPINM NAME,
DECODE (BITAND (KSPPIFLG / 256, 1), 1, 'TRUE', 'FALSE') SESMOD,
DECODE (BITAND (KSPPIFLG / 65536, 3),
1, 'IMMEDIATE',
2, 'DEFERRED',
3, 'IMMEDIATE',
'FALSE')
SYSMOD,
KSPPDESC DESCRIPTION
FROM SYS.X_$KSPPI X
WHERE X.INST_ID = USERENV ('INSTANCE')
AND TRANSLATE (KSPPINM, '_', '#') LIKE '#%'
ORDER BY 1;

( some information presented is from DBA Pool by Vigyan Kaushik )