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

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Sat, 03 Jul 2004 15:26:29 +0200
Message-ID: <mucde0dqvumiosogdkfdt187v3op1ugcgv@4ax.com>

On Sat, 03 Jul 2004 11:44:46 +0200, cat54me <cat54me_at_yahoo.it> wrote:

>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!

The bug description says it is
Fixed: 8174 9201
so in 8.1.7 and 9i R2.
You need to upgrade

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jul 03 2004 - 08:26:29 CDT