SQL to Find All initialization parameter (including Hidden )

This script need to be run as "sys" account

sqlplus "/ as sysdba"

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


Tested with version 9+


Satyesh