Select Name
Value
, decode (isdefault, 'true', 'y', 'n') AS "default"
, decode (ISEM, 'True', 'Y', 'N') AS Sesmod
Decode (isym, 'immediate', 'i',
'DeferRed', 'D',
'False', 'n') AS SYSMOD
, decode (imod, 'modified', 'u ",
'Sys_modified', 's', 'n') AS Modified
, decode (Iadj, 'True', 'Y', 'N') AS Adjusted
, Description
From (--GV $ SYSTEM_PARAMETER
SELECT X.INST_ID AS Instance
, x.indx 1
, KSPPINM AS NAME
, KSPPITY
, KSPPSTVL As Value
, ksppstdf as itfault
, decode (Bitand (KSPPIFL / 256, 1), 1, 'True', 'False') AS ISEM
Decode (Bitand (KSPPIFL / 65536, 3),
1, 'Immediate', 2, 'DeferRed', 'false') as ISYM
, Decode (Bitand (Ksppstvf, 7), 1, 'MODIFIED', 'FALSE') AS IMOD
, Decode (Bitand (Ksppstvf, 2), 2, 'True', 'false') AS IADJ
, Ksppdesc As Description
From x $ ksppi x
, x $ ksppsv y
Where x.indx = y.indX
And Substr (ksppinm, 1, 1) = '_'
And x.inst_id = uchesserenv ('instance ")
)
ORDER BY NAME
