Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 28, 2009 at 09:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded