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
;