View hidden parameters in Oracle

Hidden parameters are used internally by 0racle and start.

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

1. SELECTI. ksppinmName,
2. I. ksppdesc description,
3. CV. ksppstvl VALUE,
4. CV. ksppstdf isdefault,
5. DECODE (BITAND (CV. ksppstvf, 7 ),
6. 1,'Modified',
7. 4,'System _ mod',
8. 'False')
9. Ismodified,
10. DECODE (BITAND (CV. ksppstvf, 2), 2,'True','False') Isadjusted
11. FROMSys. x $ ksppi I, sys. x $ ksppcv CV
12. WHEREI. inst_id = USERENV ('Instance')
13. ANDCV. inst_id = USERENV ('Instance')
14. ANDI. indx = CV. indx
15. ANDI. ksppinmLIKE '/_ %' ESCAPE '/'
16. ORDER BYREPLACE(I. ksppinm,'_','');

 

1. SELECTKsppinm, ksppstvl, ksppdesc
2. FROMX $ ksppi x, x $ ksppcv y
3.  WHEREX. indx = y. indxANDTRANSLATE (ksppinm,'_','#')LIKE '# %';

Example: to view the parameter values of _ db_block_hash_buckets

1. SELECTKsppinm, ksppstvl, ksppdesc
2. FROMX $ ksppi x, x $ ksppcv y
3.  WHEREX. indx = y. indxANDKsppinm ='_ Db_block_hash_buckets';