OraFAQ Forum: Performance Tuning » unable to allocate 4128 bytes of shared memory ("shared pool

Home » RDBMS Server » Performance Tuning » unable to allocate 4128 bytes of shared memory ("shared pool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to allocate 4128 bytes of shared memory ("shared pool [message #125363]

Fri, 24 June 2005 12:59

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 06:21:34 CST 2025