Re: ORA-04031: unable to allocate 8192 bytes of shared memory

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 02 Jul 2004 23:55:36 GMT
Message-ID: <pan.2004.07.02.23.55.36.272045@sbcglobal.net>

On Fri, 02 Jul 2004 14:12:06 +0200, cat54me wrote:

> On 7/2/04 1:03 PM, Mladen Gogala wrote:
>

>> No, I listed a bug for 8i, but the same bug still aplies to 9i R1.
>> It was fixed in 9.2.0.3

>
> What's the bug ID for the 9i R1 release?
>
> Thanks!

Bug id is 2208570. Here is the text from 9.2.0.1 readme file:

<Bug:2208570> Fixed: 8174 9201

Hangs / Spins
Star Transformation

Infinite recursion occurs during query optimization if a query contains an unmergeable view, and the view optimization involves star transformation , and the query is being probed for summary rewrite (or any other case involving evaluation of the view cardinality) .
This can show up as a spin, ORA-4030 or ORA-4031 error

Good luck. I am sorry for posting bug for the wrong release.

-- 
Well-behaved women seldom make history

Received on Fri Jul 02 2004 - 18:55:36 CDT