Show non-default parameters in the table v$parameter
Show non-default parameters in the table v$parameter
SQL Code
1set pages 999 lines 100 2col name format a30 3col value format a50 4select name 5, value 6from v$parameter 7where isdefault = 'FALSE' 8and value is not null 9order by …
Read MoreReset or unset a Oracle parameter in the spfile
Setting a parameter to =' ' often isn't enough. Do this instead.. The sid='*' bit is always necessary, even in non RAC database.
SQL Code
1alter system reset <parameter> scope=spfile sid='*' 2/
Sample Oracle Output:
1no rows selected 2SQL>
Purpose:
- To …
Read More