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!

Advice on Shared Pool Size

Zahid RahimDec 16 2009 — edited Dec 18 2009

Dear All DBA's
I am using oracle 10g 10.1.0 on windows 2003 with 2GB Ram.

I am getting ORA-04031 Unable to allocate memory error and this error disappears automatically after few seconds. Please advice me what should i change like the shared pool sizes etc.

when i search init.ora i have only one file in my server with the name init.ora.7192009121911 at location c:\oracle\product\10.1.0\admin\dborcl\pfile
with the information below

###########################################
# Pools
###########################################
java_pool_size=50331648
large_pool_size=8388608
shared_pool_size=83886080

Now advice me what should i do as i am not a DBA at all.

This post has been answered by Maran Viswarayar on Dec 18 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2010

Added on Dec 16 2009

#general-database-discussions

22 comments

4,681 views