Oracle hidden parameters…

Checking the value of a hidden parameter (and also normal parameters – just in case it’s moved to being visible)

select n.ksppinm pd_name, c.ksppstvl pd_value, n.ksppdesc pd_descr
from x$ksppi n, x$ksppcv c
where n.indx=c.indx
and (
   lower(n.ksppinm) like lower('%kgl%') 
   or lower(n.ksppdesc) like lower('%kgl%')

setting in sqlplus

SQL> alter system set "_kgl_debug"="name='XMLTYPE' schema='SYS' namespace=1 debug=33554432, name='XMLTYPE' schema='SYS' namespace=2 debug=33554432" scope=both sid='*';

System altered.

SQL> alter system set "_kgl_hot_object_copies"=12  scope=both sid='*';



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s