Re: ORA-4030 out of process memory

From: Bart the bear <bartthebear_at_gmail.com>
Date: 15 Mar 2006 08:27:12 -0800
Message-ID: <1142440032.611951.200490@p10g2000cwp.googlegroups.com>

dbaplusplus_at_hotmail.com wrote:
> I disabled. automatic pga memory management by setting
> workarea_size_policy=MANUAL and setting SORT_AREA_SIZE=200M.
> I still get out of process memory but somehow my third party aplication
> is not showing any Oracle error code. It shows
> a very long sql statement which it was executing and sql statement is
> chopped,
>
> I am wondering whether it is an application issue where an unusally
> long sql statement is dynamically being generated,
>
> There must be some limit to length of sql statement. What is this
> limit, I will like to know?
>
> Thanks

DBA--, you may have a limitation on your virtual address space. I know that
such thing exists on HP-UX and that default is not very big. When you take
into account that SGA is also mapped into the address space, you may wish to contact your system administrator who will need to relink the kernel.
I don't remember which parameter it was, but your SA has a tool called "SAM"
which lists all of those parameters. SAM has been around for so long and has
changed so much that it should be called Son of SAM. Received on Wed Mar 15 2006 - 10:27:12 CST