Hidden Initialization Parameters



My OraFAQ Blog

Contact me

See the values of hidden initialization parameters.

select pin.ksppinm called, pcv.ksppstvl itsvalue
from sys.x$ksppi pin, sys.x$ksppcv pcv
where pin.inst_id=userenv('Instance')
and pcv.inst_id=pin.inst_id
and pin.indx=pcv.indx
and pin.ksppinm like '\_%' escape '\'

Note: Proofread any scripts before using. Always try scripts on a test instance first. I'm not responsible for any damage, even if you somehow manage to make my scripts corrupt every last byte of your data, set your server on fire and serve you personally with an eviction notice from your landlord!
All scripts and tips © Natalka Roshak 2001-2005.
Enjoy the FREE tips folks...