REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_db_init.sql
REM
REM <SQLDIR_GRP>INIT</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports INIT file parameters
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_db_init.sql
REM 
REM Example:
REM	s_db_init.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM


set lines 132
set pages 90
col name format a35 heading "Parameter Name"
col value format a25 heading "Parameter Value"
col def format a7 heading "Default"
col mods format a9 heading "Sys|Can Mod"
col description format a45 heading "Description"

select	name
,	value
,	decode(isdefault,'TRUE','Yes','FALSE','No')	def
,       ISSYS_MODIFIABLE mods
,	description
from	v$parameter
where name like '&par_name_like'
order by name
/