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!

oracle 11g : ORA-00384 insufficient memory to grow cache

653772Sep 29 2008 — edited Mar 19 2010
Hi ,

I am trying to manually set the db_cache_size and I am getting the following error :


SQL> alter system set sga_max_size=100M scope=spfile;

System altered.


SQL>alter system set db_cache_size=50M scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00384: Insufficient memory to grow cache

Please give me any suggestions.
-Nanjappan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2010
Added on Sep 29 2008
3 comments
11,136 views