Show non-default parameters

select name
,      value
from   v$parameter
where  ismodified != 'FALSE'
/

or for name='parameter' style...
 
set pages 999 lines 100
select 	name || '=' || decode(type, 2, '''') || value
	|| decode(type, 2, '''') parameter
from	v$parameter
where	isdefault = 'FALSE'
and	value is not null
order	by name
/

Author Profile

sysdba ;

Other posts by sysdba

Author's web site



Are you satisfied with this blog?
Why not subscribe our RSS Feed? you will always get the latest post.


Hi, Be the first leave some reply

Leave A Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



sponsored link