Re: ORA-04031
Date: 29 Jan 2003 16:36:32 -0800
Message-ID: <2687bb95.0301291636.5acde03b_at_posting.google.com>
patrice.lenoir_at_eurotunnel.com (Patrice LENOIR) wrote in message news:<28470373.0301281120.5567e168_at_posting.google.com>...
> Hi
>
> I experience since Monday the ORA-04031 unable to allocate 4096 bytes
> of shared memory. I've increase the shared_pool from 150MB to 300MB
> and it doesn't resolve the problem.
>
> I'd like to know from this group the experience of the others and how
> they resolve it?.
>
> thank's
>
> patrice
What version of Oracle are you on? There have been numerous shared pool space management bugs, which could be responsible depending on your version. If you have support you best bet might just be to open an iTAR. When we migrated from 8.0.5 to 8.1.7 we had to add 25% to our shared pool after applying a patch for one bug to run the same applications. When we went to the 64 bit version we had to double our shared pool size.
HTH -- Mark D Powell -- Received on Thu Jan 30 2003 - 01:36:32 CET