Re: ORA-4030 out of process memory

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 09 Mar 2006 23:21:13 +0100
Message-ID: <duq9oa$v9q$00$1@news.t-online.com>

Sybrand Bakker schrieb:
> On 9 Mar 2006 12:16:46 -0800, dbaplusplus_at_hotmail.com wrote:
>

>> I have read many articles on metalink as well as on internet, however,
>> cannot find the actual cause.

>
> shared pool fragmentation caused by not using bind variables.
> Consequently, increasing the shared pool will not help.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Shared pool fragmentation usually cause ORA-4031, OP is getting ORA-4030, which indicates lack for process memory. Having 20Gb free memory on the server and hitting this error sounds a little strange however.

Best regards

Maxim Received on Thu Mar 09 2006 - 16:21:13 CST