param.sql

-- 
-- Title :       param.sql 
-- Description : To display current setting of 
--               a given parameter. 
-- 
-- Usage/Notes : Supply all or part parameter 
--               name when prompted.
-- 
-- Copyright :   ABCdba.com 2005 
-- 
 
SET TERMOUT OFF 
STORE SET save_env.sql REPLACE 
SET TERMOUT ON 
 
CLEAR BREAKS 
CLEAR COLUMNS 
CLEAR COMPUTES 
 
COL name FOR a42 HEA 'Parameter Name' 
COL sess FOR a37 HEA 'Current Setting' 
 
SET PAGESIZE 20 
SET VERIFY OFF 
 
SET PAUSE ON 
SET PAUSE More... 
SET WRAP ON 
 
SELECT 
name, value 
FROM 
v$parameter 
WHERE 
name like '%&Parameter_Name%' 
ORDER BY 
name 
/ 
 
@save_env.sql 
host rm save_env.sql 
SET TERMOUT ON

© copyright 2001-2014 ABCdba.com | all rights reserved