Using ALTER SYSTEM RESET one can delete parameter from spfile if the parameter is in the spfile. Example: -- shows the parameter is in the spfile $ pwd /u01/oracle/product/10.2.0/db_1/dbs $ strings spfileTEST.ora | grep open *.open_cursors=100 -- Login to SQL*Plus, scope has to spfile and sid has to be supplied. When '*' is specified it … Continue reading How to delete/reset a parameter in spfile using ALTER SYSTEM? →