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

On 7/3/04 1:55 AM, Mladen Gogala wrote:

> 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

Thanks for the info.
Is there a patch to apply to Oracle 9i R1 to fix the bug?

Thanks! Received on Sat Jul 03 2004 - 04:44:46 CDT