Spfile

Reset or unset a Oracle parameter in the spfile Setting a parameter to = ' ' often isn't enough. Do this instead. On an instance started with an spfile, sid='' is the default, so the clause is optional; it is shown here to make the scope explicit. SQL Code 1alter system reset <parameter> scope=spfile sid='' 2/ Sample …