Urgent ! ORA-04031 error

Chris,

looks like your shared_pool is too small, so ....

edit initSID.ora file and increase the value in the SHARED_POOL_SIZE parameter from what it is, to something bigger. How much bigger ?
Good question.

I usually find that about 5M increase is ok, but this all depends on what is in the pool and what needs to go in, whether there are pinned packages etc etc etc. (It's a black art !)

After changing the setting, close and restart the instance otherwise it won't take effect.

Regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


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

-----Original Message-----

From: Chris [mailto:chris.lo_at_cyberwisdom.net] Posted At: Wednesday, October 10, 2001 11:29 AM Posted To: server
Conversation: Urgent ! ORA-04031 error
Subject: Urgent ! ORA-04031 error

I wrote an servlet application that use Oracle 8.1.6 as the database. The
servlet works fine for servel months and the application is in the production mode. However users get the following error when access one of
the page:

ORA-04031: unable to allocate 184 bytes of shared memory ("shared pool","unknown object","sql area","qerixs : rixalo")

Any idea is highly appreciated.
Chris Received on Wed Oct 10 2001 - 05:53:39 CDT