Re: Oracle10G error!!!!

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 28 Oct 2004 09:08:40 +0200
Message-ID: <clq5tp$9mg$1@news.BelWue.DE>

Howard J. Rogers wrote:
> Praveen wrote:
>

[...]

>>  __large_pool_size        = 20971520
>>  large_pool_size          = 4194304
>>  __java_pool_size         = 20971520
>>  java_pool_size           = 20971520
>>  sga_target               = 167772160

[...]

>>
>>I'm getting the following error frequently. And around 35 programmers
>>will connect daily.
>>
>>ORA-00604: error occurred at recursive SQL level 1
>>ORA-12414: internal LBAC error: zllcsi:OCIStmtExecute
>> Error: ORA-04031: unable to allocate 64088 bytes of shared memory
>>("large pool","unknown object","session heap","kksfal:1:frame
>>segment")
>>
>>Can anybody help me why this error is coming?

>
>
> Yes, it's what the error message explicitly says. You've run out of space in
> the large pool, which is apparently just 4MB big. Give it some more memory.
>
> Regards
> HJR
>

I don't quite understand your comment, and although David seems to agree, could you please elaborate a bit more:

SGA_TARGET is set, so the pool should be dynamically managed and the 4MB figure is just the minimum. Oracle realised already that it needed 5 times the number: __large_pool_size = 20971520

I haven't researched Automatic Shared Memory Tuning sofar, but I'd expect that the, as the New Features Guide puts them,'self tuning algorithms' would prevent such a situation from happing.

What am I missing?

Cheers,
Holger Received on Thu Oct 28 2004 - 02:08:40 CDT