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

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 Fri Aug 09 1996 - 00:00:00 CEST