Hidden-Parameters

-- 
-- Title :       hidden.sql 
-- Description : To display hidden parameters 
--               and their settings. 
-- 
-- Usage/Notes : 
-- 
-- Copyright :   ABCdba.com 2005 
-- 
 
SET TERMOUT OFF 
STORE SET save_env.sql REPLACE 
SET TERMOUT ON 
 
CLEAR BREAKS 
CLEAR COLUMNS 
CLEAR COMPUTES 
 
COL parm FOR a44 HEA 'Parameter' 
COL sess FOR a17 HEA 'Session Value' 
COL inst FOR a17 HEA 'Instance Value' 
 
SET PAGESIZE 20 
SET WRAP ON 
 
SET PAUSE ON 
SET PAUSE More... 
 
SELECT 
a.ksppinm parm, 
b.ksppstvl sess, 
c.ksppstvl inst 
FROM 
x$ksppi a, x$ksppcv b, x$ksppsv c 
WHERE 
a.indx = b.indx 
AND 
a.indx = c.indx 
AND 
SUBSTR( ksppinm, 1, 1 ) = '_' 
ORDER BY 
a.ksppinm 
/ 
 
@save_env.sql 
host rm save_env.sql 
SET TERMOUT ON