Re: [Q] ORA-04031 unable to allocate shared memory

This is a know bug on 7.2.2 and 7.2.3 (Bug 329974) You can ask a patch from your Oracle support. We applied the patch and we never had ORA-4031 any more.

Bob Morrison wrote:
>
> MCC wrote:
> >
> > I got an error message on client side said "ORA-04031; unable to allocate
> > 740 bytes of shared memory". I have following questions can someone help me on
> > it:
> >
> > 1. Does their has a way to check how many free SGA Database has?
> > 2. Someone told me use "select free_space from v$shared_pool_reserved"
> > to check free space. The output I got always 0 even I use "alter
> > system flush shared_pool". I shutdown database then start it
> > up, the free_space still 0.
> > 3. will this error write to any error log or not? Where is it?
> > The Oracle server is reside on SUN Sparc with Solaris 2.5 and
> > Oracle 7.2.3.
> > 4. When this error happen I check their has onlt one user. Why the
> > free_space is 0?
> > 5. the "shared_pool_size = 9000000" on my init.ora. How big size
> > should I change? How to match the size on SOLARIS /etc/system?
> >
> > Thank you for help.
>
> We get this message when we were installing PeopleSoft. My understanding is that this
> is a known problem with 7.2.3. My workaround for this problem was to write a
> cron job which would execute an "alter system flush shared_pool" every 10 minutes
> while I was doing my install. Hope this helps.
>
> Bob Morrison
> rmorrison_at_cahners.com
  Received on Mon Aug 12 1996 - 00:00:00 CEST