-
Hidden parameters
Just got done applying the april AIVA and during the patch apply, it messes with the
_system_trig_enabled parameter.
If you query V$PARAMETER it's not in there. NE1 know what view that bugger is kept so I can look at it? I want to know if the patch put it back to normal after it was done. I have the most sneakest feeling that it didn't because I'm not finding it anywhere in the patch code.
-
Code:
select a.ksppinm name, b.ksppstvl value, b.ksppstdf isdefault,
decode(a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file',
a.ksppity) type,
a.ksppdesc description
from sys.x$ksppi a, sys.x$ksppcv b
where a.indx = b.indx
and a.ksppinm like '\_%' escape '\'
order by name
##Execute this query to know all hidden parameters
##connect with sys or internal
Abhay.
-
Thanks abhaysk! you da man!