Skip to Main Content
Forums

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!

sql command to set shared_pool_size

789589Feb 20 2012 — edited Feb 21 2012
Dear Guru:

what is sql command to set shared_pool_size = 400mb

I have try below SQL command but not work
alter system set shared_pool_size=400M scope=both;

error=>ORA-02097 parameter cannot be modified because specified value is invalid.
ORA-04033 insufficient memory to grow pool.



Thx in advance.
This post has been answered by sb92075 on Feb 20 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2012
Added on Feb 20 2012
#general-database-discussions
10 comments
6,220 views