Search notes:

ORA-32010: cannot find entry to delete in SPFILE

SQL> alter system   set statistics_level = all;
System SET altered.

SQL> alter system reset statistics_level;
System RESET altered.
Trying to reset a parameter that is already having the default value throws the ORA-32010 error:
SQL> alter system reset statistics_level;
ORA-32010: cannot find entry to delete in SPFILE

See also

Server parameter file
Other Oracle error messages

Index