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 isdefault,
DECODE (BITAND (ksppiflg / 256, 1),
1, 'TRUE',
'FALSE'
) AS isem,
DECODE (BITAND (ksppiflg / 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 = USERENV ('Instance'))
ORDER BY NAME;