Re: Session PGA memory max exceeded 2 GB and crashes.

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Wed, 20 Dec 2006 09:16:43 -0500
Message-id: <1166624203l.2819l.0l@medo.noip.com>

On 12/20/2006 08:57:04 AM, Norman Dunbar wrote:

>
> ORA-07445: exception encountered: core dump [11] [3221215928]
> [552153088] [0] [] []
> ORA-04030: out of process memory when trying to allocate 1048 bytes
> (koh-kghu call ,pl/sql vc2)
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06500: PL/SQL: storage error

Norman, you got exception signal 11, segmentation violation. HP-UX 11.11 is a 64-bit OS so maximum segment size should be slightly larger then 2GB, unless there is an implicit or explicit setting in your OS preventing users from creating segments larger then 2GB. Is there any such limit? I am not well versed in HP-UX any more, but I'd look into SAM and check the OS parameters. Some other flavors have such things configured in /etc/security/limits.conf You should enlist help of your local SOB (System / Operations Boss) to help you out with the OS parameters.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 20 2006 - 08:16:43 CST