Differences

This shows you the differences between two versions of the page.

--- init.ora [2018/12/06 21:05] – created 91.177.234.129
+++ init.ora [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Init.ora ======
+==== Show non-default parameters ====
+ <code>
-=====Show non-default parameters=====
+set pages 100
- <code>0@@</code>
+set lines 100
-=====Reset/Unset a spfile parameter=====
+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;
+</code>
+==== Reset/Unset a spfile parameter ====
+<code>
  alter system reset <parameter> scope=spfile sid='*'