Database Reference
In-Depth Information
from x$ksppi x, x$ksppcv y
where (x.indx = y.indx)
and (
(translate(ksppinm,'_','#') not like '##%')
and
(
(translate(ksppinm,'_','#') not like '#%')
or (ksppstdf = 'FALSE') or (bitand(ksppstvf,5) > 0)
)
);
Thus, we obtain a mapping from the cryptic column names of
X$KSPPI
and
X$KSPPCV
to the
well-understandable column names of the view
GV$PARAMETER
. The mappings for
X$KSPPI
and
X$KSPPCV
are in Table 9-3 and Table 9-4 respectively.
Table 9-3.
Columns of X$KSPPI
X$ Table Column
GV$ View Column
X$KSPPI.ADDR
n/a
X$KSPPI.INDX
GV$PARAMETER.NUM
X$KSPPI.INST_ID
GV$PARAMETER.INST_ID
X$KSPPI.KSPPINM
GV$PARAMETER.NAME
X$KSPPI.KSPPITY
GV$PARAMETER.TYPE
X$KSPPI.KSPPDESC
GV$PARAMETER.DESCRIPTION
X$KSPPI.KSPPIFLG
GV$PARAMETER.ISSES_MODIFIABLE
,
GV$PARAMETER.ISSYS_MODIFIABLE
,
GV$PARAMETER.ISINSTANCE_MODIFIABLE
X$KSPPI.KSPPILRMFLG
GV$PARAMETER.ISDEPRECATED
X$KSPPI.KSPPIHASH
GV$PARAMETER.HASH
The column
X$KSPPI.KSPPIFLG
is a flag that is expanded to three separate columns in
GV$PARAMETER
using
BITAND
and
DECODE
.
Table 9-4.
Columns of X$KSPPCV
X$ Table Column
GV$ View Column
X$KSPPCV.ADDR
n/a
X$KSPPCV.INDX
GV$PARAMETER.NUM
X$KSPPCV.INST_ID
GV$PARAMETER.INST_ID
X$KSPPCV.KSPPSTVL
GV$PARAMETER.VALUE
X$KSPPCV.KSPPSTDVL
GV$PARAMETER.DISPLAY_VALUE