select x.ksppinm name, y.ksppstvl value, y.ksppstdf isdefault, decode(bitand(y.ksppstvf,7),1,‘MODIFIED’,4,‘SYSTEM_MOD’,‘FALSE’) ismod, decode(bitand(y.ksppstvf,2),2,‘TRUE’,‘FALSE’) isadj
from sys.x
k
s
p
p
i
x
,
s
y
s
.
x
ksppi x, sys.x
ksppix,sys.xksppcv y where x.inst_id = userenv(‘Instance’) and
y.inst_id = userenv(‘Instance’) and x.indx = y.indx order by
translate(x.ksppinm, ’ _’, ’ ');
select x.ksppinm name, y.ksppstvl value, y.ksppstdf isdefault, decode(bitand(y.ksppstvf,7),1,‘MODIFIED’,4,‘SYSTEM_MOD’,‘FALSE’) ismod, decode(bitand(y.ksppstvf,2),2,‘TRUE’,‘FALSE’) isadj
from sys.x
k
s
p
p
i
x
,
s
y
s
.
x
ksppi x, sys.x
ksppix,sys.xksppcv y where x.inst_id = userenv(‘Instance’) and
y.inst_id = userenv(‘Instance’) and x.indx = y.indx and x.ksppinm like ‘%_&par%’ order by
translate(x.ksppinm, ’ _’, ’ ');
Enter value for par: bind_peek
old 3: y.inst_id = userenv(‘Instance’) and x.indx = y.indx and x.ksppinm like ‘%_&par%’ order by
new 3: y.inst_id = userenv(‘Instance’) and x.indx = y.indx and x.ksppinm like ‘%_bind_peek%’ order by
NAME
VALUE
ISDEFAULT ISMOD ISADJ
_px_bind_peek_sharing
TRUE
TRUE FALSE FALSE