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!

shared_pool_reserved_size

538299Aug 20 2009 — edited Aug 20 2009

Hi

Can someone please help me out in this:

SQL> alter system set shared_pool_reserved_size=64m scope=spfile;

System altered.

SQL> alter system set shared_pool_size=800m scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00821: Specified value of sga_target 500M is too small, needs to be at least 844M
SQL> startup
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings

thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2009

Added on Aug 20 2009

#general-database-discussions

10 comments

7,056 views