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 databases. SQL Code 1alter system reset <parameter> scope=spfile sid='' 2/ Sample Oracle Output 1no rows selected 2SQL> Purpose: To reset a specified …