Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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 G. Vicario 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.