Init.ora - Revision history

Stuart at 21:12, 10 November 2012

2012-11-10T21:12:09Z

Stuart at 21:10, 10 November 2012

2012-11-10T21:10:27Z

Stuart at 21:10, 10 November 2012

2012-11-10T21:10:01Z

Stuart at 21:09, 10 November 2012

2012-11-10T21:09:20Z

Stuart at 21:06, 10 November 2012

2012-11-10T21:06:57Z

Stuart: 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 ..."

2012-11-10T21:06:43Z

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 ..."

New page

===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
and isdefault = 'FALSE'
and value is not null
order by name;

← Older revision		Revision as of 21:12, 10 November 2012
Line 10:		Line 10:
	order by name;		order by name;
	</pre>		</pre>
		+	===Reset/Unset a spfile parameter===
		+	alter system reset <parameter> scope=spfile sid='*'

@@ Line 7: / Line 7: @@
 where  1=1
 and    isdefault = 'FALSE'
-and    value is not null
+and    value     is not null
 order  by name;
 </pre>

@@ Line 1: / Line 1: @@
 ===Show non-default parameters===
-  <pre>set pages 100
+  <pre>
- set lines 100
+set pages 100
- select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter
+set lines 100
- from   v$parameter
+select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter
- where  1=1
+from   v$parameter
- and    isdefault = 'FALSE'
+where  1=1
- and    value is not null
+and    isdefault = 'FALSE'
- order  by name;
+and    value is not null
 </pre>