optimizer_features_enable

[Former Member]

hi.

who know, how to delete(deactivate) paramer optimizer_features_enable according to note 830567.

[Former Member]

Hi Denis,

To Delete means resetting that parameter to default value. To do that, SAP has provided BRTOOLS or you can use directly BRSPACE.

To access Oracle parameter, just type brspace -f dbparam (using your ora(sid) user).

ardhian

[Former Member]

Hello,

One "clarification", once the parameter has been deleted using the methods indicated, it will take its default value.

Deleting parameters from spfile or pfile does not mean allways that they "dissapear".

That is the efect searched when it is indicated to delete a parameter on the note.

[former_member200235]

Hi Denis

This depends on whether the spfile has been implemented for managing your database parameters.

If you are using spfile then execute the following command as sysdba :

alter system reset optimizer_features_enable scope=spfile;

Then restart the database.

If you are not using spfile then edit the file $ORACLE_HOME/dbs/init<SID>.ora and put a hash '#' in front of the parameter then save the changes. Restart the database for it to take effect.

Cheers

Adrienne