Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to change the OPTIMIZER_FEATURES_ENABLE parameter in a local installation of Oracle 9i (32bit 9.2.0.1.0 Enterprise Edition running on Windows Server 2003) in an attempt to reproduce a performance issue reported by a client but I can't figure out how to do it. Both ALTER SESSION and ALTER SYSTEM statements trigger this error (even if run as SYS):

ORA-02095: specified initialization parameter cannot be modified

How can I change it?

Update:

The steps I followed (thanks to Gary's answer) were this:

  1. Create an empty file: C:\oracle\ora92\DBS\INIT.ORA

  2. Edit the file to add: optimizer_features_enabled = 8.1.7

  3. Launch Windows service manager

  4. Restart the service called OracleServiceFOO, where FOO is my instance name

share|improve this question
up vote 2 down vote accepted

It's a static parameter so it needs to be changed in the pfile / spfile and then the instance restarted.

share|improve this answer
    
Thank you. The article omits many things but it helped me to figure out the necessary steps. I've updated the question to reflect them. – Álvaro González Jun 3 '11 at 8:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.