Reset 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 …