check the following configuration

 

your physical memory size,

32 or 64bit OS,

may consider using hugemem kernel instead of smp kernel in Linux,

 

before you make any changes in the database site.

 

You can try to flash your shared pool to see if this helps. (ALTER SYSTEM FLUSH SHARED_POOL; )

 

 

 

Cindy

 

 

 

On 7/11/06, tristan.van.essen@accenture.com <tristan.van.essen@accenture.com > wrote:

Hi John,

" Google is your friend…" a wise man once said.

Maybe this helps you with your problem:

http://ora-04031.ora-code.com/

http://www.cryer.co.uk/brian/oracle/ORA04031.htm

Regards,

Tristan

------------------------------------------------------------------------------------

Tristan van Essen

Accenture Technology Solutions AG

Baslerstrasse 60

CH-8048 Zürich

Office: +41 44 405 3245

Mobile: +41 79 654 0592

Email: tristan.van.essen@accenture.com

_____________________________________________
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of John Dunn
Sent: Dienstag, 11. Juli 2006 10:23
To: 'oracle-l digest users'
Subject: Oracle 10 on linux

I am running Oracle 10 R2  on linux with automatic memory management and keep getting the following error :

ORA-04031: unable to

allocate 3888 bytes of shared memory ("shared pool","unknown object","sga

heap(1,0)","kglsim object batch"

Anyone else seen this?

John Dunn

Product Consultant

Direct Dial +44 (0) 117 373 6122

Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.

Tel: +44(0) 117 373 6114

Fax: +44 (0) 117 373 6115

www.sefas.com

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.