ORA-04031: unable to allocate 4200 bytes of shared memory

From: Johnson Poovathummoottil <joni_65_at_yahoo.com>
Date: Wed, 3 May 2000 07:06:28 -0700 (PDT)
Message-Id: <10486.104801@fatcity.com>

Hi,

Could anyone point out the reason for the folowing error?
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")

The Docs tell me to pin the package or increase shared memory.

 This is a test db I have 5M of shared pool and this is the only SQL running. Does it mean my SQL needs more than 5M to parse and execute?

Johnson

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ Received on Wed May 03 2000 - 09:06:28 CDT