how to reset parameter?

[Former Member]

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

[Former Member · Accepted solution]

Correct syntax is:

ALTER SYSTEM RESET <parameter_name> scope = spfile sid = '*';

It's '*', not 'DPJ' .

And I would leave out the "" around "dml_locks" (Not sure about that.)

Source: Sap note 601157.

Edited by: Joe Bo. on Apr 28, 2009 11:17 AM

[Former Member · Accepted solution]

Sorry, wrong thread

Edited by: Rich Evans on Apr 28, 2009 3:45 PM

[Former Member · Accepted solution]

Victor

What parameter you have to change?

Thanks & Regards

Babu

[Former Member · Accepted solution]

remove the quotes around "dml_locks"

that should do it for you.