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

My First Blog

Hi

This is my first blog, I started to blog after getting inspired by all my ex-team members.

I've been an Oracle DBA and Sybase DBA for about 10 years, but there is still a lot to learn. Currently I am working as Sr. Oracle Application DBA. In Database and Architech world knowledge is unlimited. Every day you come across somthing new. This blog will help me capturing those little tips which I usually misplace and can be used as a source when required. This will definitely help me saving some search time.

Satyesh