Re: ORA-4030 out of process memory

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 18 Mar 2006 09:54:06 +0100
Message-ID: <vein12h11eaice3vvdtkfq6mg0gccqjqh3@4ax.com>

On 15 Mar 2006 08:48:25 -0800, dbaplusplus_at_hotmail.com wrote:

>My System Admin already looked into all the kernal parameters - there
>is 16GB free memory on that box and 48 GB free swap space.
>
>It is defintely some Oracle "PGA" kind of limitaion (e.g., length of
>sql statement or some memory for sql statamenet parsing etc ..)
>Since it is third part applicaion, I do not have access to source code.

Limits are documented. The maximum length of a sqlstatement is documented in the Oracle Reference Manual.

However sort_area_size is a limit which applies *PER SORT*. If there are several sort per statements (which is quite customary), everyone of them will consume ultimately sort_area_size bytes. And evidently a sort_area_size of 200M is way too high, not to say utterly ridiculous.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Mar 18 2006 - 02:54:06 CST