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: 1 2no rows selected 3SQL> Purpose: To …