set lines 190 col name for a60 col value for a15 col description for a70 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;