Skip to Content
Former Member
Apr 28, 2009 at 09:06 AM

how to reset parameter?


an earlywatch report tells me some parameter should not be setted, but I use "alter system reset "dml_locks" scope=spfile sid='DPJ' command ,it does not work, I get an error.

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

show parameter , I can see dml_locks is 4000.

Could you give me some advices.

Edited by: victor on Apr 28, 2009 11:10 AM