Home » RDBMS Server » Performance Tuning » unable to allocate 4372 *
unable to allocate 4372 * [message #65400] Thu, 09 September 2004 01:42 Go to next message
praveen K
Messages: 1
Registered: September 2004
Junior Member
am running ORACLE 9i on Linux machine .... SHARED_POOL_SIZE is set to 9000000 ..i keep getting the error <ORA4031>

how much can i increase the SHARED_POOL_SIZE to over come this exception...  RAM size is 1GB...

my application is a gaming application, when the load on the servers are high i get the above DB Error.

forgive me if this question seems to be sill am a rookie in this area..

 

please reply be  back soon
Re: unable to allocate 4372 * [message #65407 is a reply to message #65400] Fri, 10 September 2004 01:42 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Oracle have a white paper that say that you can use half to 2/3 of memory on the box for oracle. On our production machines we usually set SPS at 60-100 Mb all depending on Hit ratio's and size of DB. 9mb is way to small. Try 60mb and go from there.

Hope that helps.

Also a little tip, If you haven't got access to Metalink then try typing in your error message into google and see what you get back.

cheers

John
Previous Topic: performance problem
Next Topic: SGA sizing
Goto Forum:
  


Current Time: Thu Feb 29 16:20:45 CST 2024