Difference between revisions of "Init.ora"
From dbawiki
(Created page with "===Show non-default parameters=== set pages 999 set lines 100 select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter from v$parameter where 1=1 ...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
===Show non-default parameters=== | ===Show non-default parameters=== | ||
| − | set pages | + | <pre> |
| − | + | 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; | ||
| + | </pre> | ||
| + | ===Reset/Unset a spfile parameter=== | ||
| + | alter system reset <parameter> scope=spfile sid='*' | ||
Latest revision as of 21:12, 10 November 2012
Show non-default parameters[edit]
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;
Reset/Unset a spfile parameter[edit]
alter system reset <parameter> scope=spfile sid='*'
