Difference between revisions of "Init.ora"
From dbawiki
| Line 1: | Line 1: | ||
===Show non-default parameters=== | ===Show non-default parameters=== | ||
| − | set pages 100 | + | <pre>set pages 100 |
set lines 100 | set lines 100 | ||
select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter | select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter | ||
| Line 8: | Line 8: | ||
and value is not null | and value is not null | ||
order by name; | order by name; | ||
| + | </pre> | ||
Revision as of 21:09, 10 November 2012
Show non-default parameters
set pages 100 set lines 100 select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter from v$parameter where 1=1 and isdefault = 'FALSE' and value is not null order by name;
