“Holly Secret Stuff, DBAtman!”
What other secrets do you have there?
Connected as sys with sysdba:
select x.ksppinm name,ksppdesc description,
y.kspftctxvl value,
y.kspftctxdf isdefault,
decode(bitand(y.kspftctxvf, 7), 1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod, decode(bitand(y.kspftctxvf, 2), 2, 'TRUE', 'FALSE') isadj
from sys.x$ksppi x, sys.x$ksppcv2 y
where x.inst_id = userenv('Instance')
and y.inst_id = userenv('Instance')
and x.indx + 1 = y.kspftctxpn
order by name;Na, na, na, na, na, na, na, na, na, na, na, na… DBAtman!
dbatman.blog 