Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to safely remove parameter

Hello,

DB16 is warning me that my Oracle DB (version 10.2.0.4.0) has the following parameter set:

OPTIMIZER_FEATURES_ENABLE

Which, according to SAP note 830576 ("Parameter recommendations for Oracle 10g), shouldn't be set.

However, it has the value "10.2.0.1".

I've searched and found this thread, here at SCN:

Changing or Deleting Oracle DB Parameter Using BRTOOLS

This thread has the following instructions:

SQL> create pfile from spfile;

Edit the pfile according to your needs

and after this:

sql> shutdown immediate

sql> create spfile from pfile;

sql> startup

Also, there will be many parameter which will take default value if you do not set it.

Since I'm an Oracle newbie, I'm wondering:

1st) Where will the pfile be created?

2nd) How can I be sure that I don't have any problems related to the last sentence: "Also, there will be many parameter which will take default value if you do not set it."

thanks

Antonio

Former Member
Former Member replied

hi...

thanks for both your answers...

this was solved with this command:

alter system reset optimizer_features_enable scope = spfile sid='*';

thanks for your help, anyway. Good information...

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question