Oracle Database Discussions

I am facing one problem on 11.1.0.6 installed on windows 2003. According to meat link document id 8881121.

from 11.1.0.6 onwards.

“ DML on the child table will take an SX lock on the parent.”

And in the same document it’s mentioned that if we want to revert back this changes we need to take the help of fix_control hidden parameter.

Now when I am changing the value of fix_control by using below command I am getting error message due to this I am unable to modify parameter value.

SQL> ALTER SYSTEM SET "_FIX_CONTROL"='5909305:OFF';
ALTER SYSTEM SET "_FIX_CONTROL"='5909305:OFF'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00940: invalid ALTER command

Now I want to revert back this changes in my database by changing value of this parameter.

Please help in solving this issue.

Any help much appreciated.

Thanks in advance.