SELECT a.ksppinm paramName,
a.ksppdesc description,
b.ksppstvl SessionValue,
c.ksppstvl InstanceValue,
decode(bitand(a.ksppiflg/256,1),1,'TRUE','FALSE') IS_SESSION_MODIFIABLE,
decode(bitand(a.ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE') IS_SYSTEM_MODIFIABLE,
decode(bitand(a.ksppiflg/524288,1),1,'TRUE','FALSE') ISPDBMODIFIABLE
FROM x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE '/%' escape '/'
AND a.ksppinm LIKE '%&1%'
ORDER BY REPLACE (a.ksppinm, '_', '');
col PARAMNAME for a50
col SESSIONVALUE for a15
col INSTANCEVALUE for a15
set lines 190
SQL> col DESCRIPTION format a20;
SQL> /
Enter value for 1: kks_parse_error_warning
old 14: AND a.ksppinm LIKE '%&1%'
new 14: AND a.ksppinm LIKE '%kks_parse_error_warning%'
PARAMNAME DESCRIPTION SESSIONVALUE INSTANCEVALUE IS_SE IS_SYSTEM ISPDB
_kks_parse_error_warning Parse error warning 100 100 FALSE IMMEDIATE TRUE
SQL>
JDBC driver when using JDBC “ResultSet.TYPE_SCROLL_SENSITIVE.
WARNING: Too Many Parse Errors And error=937 In Database Alert Log (Doc ID 2590218.1)