-- name       : parameters.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: This script lists all database parameters including 
--              the hidden ones.
-- limitation : needs access to x$ksppi and x$ksppcv
--
-- useage     : SQL> @parameters

set pages 50
set feed off
set verify off
set linesize 200

col name head "Name" for a25
col value head "Value" for a35
col def head "Default" for a8
col modd head "Modable" for a8
col adj head "Adjust" for a8

spool param.lis

select	a.ksppinm name,
	b.ksppstvl  value,
	b.ksppstdf  def,
	decode(bitand(b.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')  modd, 
	decode(bitand(b.ksppstvf,2),2,'TRUE','FALSE')  adj 
from 	sys.x$ksppi a, 
	sys.x$ksppcv b 
where	a.indx = b.indx 
and 	a.inst_id = userenv('Instance') 
and	b.inst_id = userenv('Instance') 
order by translate(a.ksppinm, ' _', ' ')
/

spool off

set pages 24
set feed on
set verify on
set lines 80