Undocumented parameters of database


SELECT X.KSPPINM NAME, DECODE(BITAND(KSPPIFLG/256, 1), 1, 'TRUE', 'FALSE') SESMOD,
DECODE( BITAND(KSPPIFLG/65536, 3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', 'FALSE' ) SYSMOD,
KSPPDESC DESCRIPTION
FROM SYS.X_$KSPPI X
WHERE X.INST_ID = USERENV('INSTANCE')
AND TRANSLATE(KSPPINM,'_','#') LIKE '#%' ORDER BY 1

Leave a Reply

Your email address will not be published. Required fields are marked *