Script: Find Hidden Initialization Parameter

Reference: http://coskan.wordpress.com/2007/02/06/how-to-view-list-of-hidden-parameters/ -- ======================================================================================== -- Find the hidden initialization parameters by keyword -- --- -- SQL> @db_init_hidden -- Enter value for param_keyword: internal -- old 17:        AND a.ksppinm like '\_%&param_keyword%' escape '\' -- new 17:        AND a.ksppinm like '\_%internal%' escape '\'

-- Name                         VALUE      DEFLT     TYPE     DESCRIPTION -- -- -  -- -- _db_block_cache_protect_internal         0          TRUE      number   protect database blocks (for s --                                                                        trictly internal use only) -- -- _disable_thread_internal_disable        FALSE      TRUE      boolean  Disable thread internal disabl --                                                                       e feature -- -- _rdbms_internal_fplib_enabled           FALSE      TRUE      boolean  enable CELL FPLIB filtering wi --                                                                        thin rdbms -- ========================================================================================

SET pages 200 SET lines 200

COLUMN name	FORMAT A40 COLUMN value	FORMAT A10 COLUMN type	FORMAT A8 COLUMN description	FORMAT A30 --- -- Hidden parameter --- SELECT a.ksppinm name , b.ksppstvl value , b.ksppstdf deflt , DECODE(a.ksppity, 		1, 'boolean', 		2, 'string', 		3, 'number', 		4, 'file', 		a.ksppity) type , a.ksppdesc description FROM sys.x$ksppi a,	sys.x$ksppcv b WHERE a.indx = b.indx AND a.ksppinm like '\_%&param_keyword%' escape '\' ORDER BY	NAME