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!

How to change the size of shared_pool_reserved_size

EdwardKingDec 28 2005 — edited Dec 30 2005

I want to change the the value of shared_pool_reserved_size,so I execute following command:
SQL> alter session set shared_pool_reserved_size=5033164 scope=spfile;
alter session set shared_pool_reserved_size=5033164 scope=spfile
*
ORA-02095: specified initialization parameter cannot be modified

Why I can't change the value of shared_pool_reserved_size? Is it a method to change the value of shared_pool_reserved_size?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2006

Added on Dec 28 2005

#general-database-discussions

10 comments

4,868 views