View hidden parameters in Oracle

Hiddenparameters is used internally by 0racle.

The hidden parameters are used internally by 0racle.

Hidden parameters are used internally by 0racle and start.

You can view all hidden parameters in the following two ways:

SELECTI. ksppinmName,

I. ksppdesc description,

CV. ksppstvl VALUE,

CV. ksppstdf isdefault,

DECODE (BITAND (CV. ksppstvf, 7 ),

1, 'modified ',

4, 'System _ mod ',

'False ')

Ismodified,

DECODE (BITAND (CV. ksppstvf, 2), 2, 'true', 'false') isadjusted

FROMSys. x $ ksppi I, sys. x $ ksppcv CV

WHEREI. inst_id = USERENV ('instance ')

And cv. inst_id = USERENV ('instance ')

AND I. indx = CV. indx

AND I. ksppinm LIKE '/_ %'ESCAPE'Http: // www.linuxeden.com /'

ORDER BYREPLACE (I. ksppinm ,'_','');

SELECTKsppinm, ksppstvl, ksppdesc

FROMX $ ksppi x, x $ ksppcv y

WHEREX. indx = y. indx and translate (ksppinm, '_', '#') LIKE '# % ';

Example: to view the parameter values of _ db_block_hash_buckets

SELECTKsppinm, ksppstvl, ksppdesc

FROMX $ ksppi x, x $ ksppcv y

WHEREX. indx = y. indx AND ksppinm = '_ db_block_hash_buckets ';