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!

Altering the Shared Pool Size

438772Mar 22 2005 — edited Mar 22 2005
I am trying to start an oracle instance and tell it to use the init.ora file. However i am receiveing an error about my pool size being too small. Please see below:



SQL> startup pfile=/home/oracle/OraHome_1/dbs/init.ora
ORA-00371: not enough shared pool memory, should be atleast 52132659 bytes

I checked init.ora and the shared_pool_size is set to 3500000. However, i tried the other settings, as it had a medium and a large option, i tried these just to see what would happen. It didn't work, and i don't think this is the problem.

I then tried this query:

SQL> SELECT shared_pool_size_for_estimate,
2 shared_pool_size_factor,
3 estd_lc_time_saved
4 FROM v$shared_pool_advice;

And it output the settings for my shared_pool_size. The setting for "level 1: 76".

Can anyone tell me if this is too low, or how to fix this problem?

Thanks,
Gary
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2005
Added on Mar 22 2005
10 comments
2,326 views