Sybrand Bakker schrieb:
> On 9 Mar 2006 12:16:46 -0800, dbaplusplus@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