Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing parallel_max_servers parameter

595695Aug 30 2007 — edited Aug 31 2007
Hi,
I'm try to change the parallel_max_servers parameter from 5 to 2 with the command below but it fails with the error ORA-02095. Could someone tell me why this error is occurring and how too change this parameter?

SQL> alter system set parallel_max_servers=2 scope=both;
alter system set parallel_max_servers=2 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Any help will be appreciated.

Steve
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2007
Added on Aug 30 2007
2 comments
4,043 views