Question Re: how to reset parameter? in Technology Q&A

how to reset parameter?

Former Member — Tue, 28 Apr 2009 09:06:03 GMT

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

Re: how to reset parameter?

Former Member — Tue, 28 Apr 2009 09:16:09 GMT

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

Re: how to reset parameter?

Former Member — Tue, 28 Apr 2009 13:44:55 GMT

Sorry, wrong thread

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

Re: how to reset parameter?

Former Member — Tue, 28 Apr 2009 14:23:34 GMT

Victor

What parameter you have to change?

Thanks & Regards

Babu

Re: how to reset parameter?

Former Member — Wed, 29 Apr 2009 19:30:40 GMT

remove the quotes around "dml_locks"

that should do it for you.