Home » RDBMS Server » Performance Tuning » unable to allocate 4128 bytes of shared memory ("shared pool
unable to allocate 4128 bytes of shared memory ("shared pool [message #125363] Fri, 24 June 2005 12:59 Go to next message
lordtorero
Messages: 1
Registered: June 2005
Location: jhjkhjk
Junior Member
somebody can help me ...
i have de follow problem ...

Errors in file /oracle/app/oracle/admin/pro_nvo/bdump/pro_nvo_smon_12360.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
n object","sga heap","multiblock rea")

and the database not response... inclusive when i try connect with SQL show the below message...

The following parameters i have in the INIT.ORA file

java_pool_size=0
large_pool_size=0
shared_pool_size=209715200
shared_pool_reserved_size=10485760

and the machine where the dbms run have de the following configuration
16 GB RAM
8 CPU's


Re: unable to allocate 4128 bytes of shared memory ("shared pool [message #125364 is a reply to message #125363] Fri, 24 June 2005 13:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please dont report the posting , to get attention.
REPORT posting is feature for to report the un-appropriate posting.
Re: unable to allocate 4128 bytes of shared memory ("shared pool [message #125591 is a reply to message #125363] Mon, 27 June 2005 18:55 Go to previous messageGo to next message
vadlamani
Messages: 39
Registered: November 2003
Member
Try tuning you shared pool & reserved pool size's....
or if u have memory increase shared pool size
Re: unable to allocate 4128 bytes of shared memory ("shared pool [message #126075 is a reply to message #125363] Thu, 30 June 2005 17:00 Go to previous messageGo to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Hi lordtorero,

Am not sure how you managed to configure 0mb for java_pool_size. Check on that.
Also, Please tell what kind of application is running on the server and during which operation you get this error.

Thanks,
Srinivas
Re: unable to allocate 4128 bytes of shared memory ("shared pool [message #126369 is a reply to message #126075] Mon, 04 July 2005 01:53 Go to previous message
ziggy
Messages: 27
Registered: July 2005
Location: Moscow, Russia
Junior Member

Hi, lordtorero!

You shared pool don't look like very big for 16Gb RAM and you may try to encrease it to up to 50% of buffer cache (db_cache_size for 9i or db_block_buffers for 8i).

If after increasing shared pool you will receive that exception again try to flush shared pool from time to time using statement:

alter system flush shared_pool;

Fragmentation of shared pool happend if you have many hard parses in your application.

Regards,
Oleg


Previous Topic: Explain plan
Next Topic: SQL*Net messages
Goto Forum:
  


Current Time: Thu Mar 28 08:09:34 CDT 2024