|
How to find Oracle Hidden Parameters ?
Oracle has many hidden parameters. You will not find them in
V$PARAMETER or see them with SHOW PARAMETERS command as these are hidden.
All these parameter start with _ (Underscore). Like _system_trig_enabled.
These parameters are undocumented. You won’t find them in Oracle
documentation. These parameters are for specific purpose only. Some of
them are OS specific and used in unusual recovery situations. Some are
also used to enable and disable new feature. You should be very much
careful while using them. Please check with Oracle Support before using
them.
Here is a query that you can use to find these parameters.
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 ;
<
/P
>
|
