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 name 10/ Sample Oracle …
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: 1 2no rows selected 3SQL> Purpose: To …
Read More