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

  • From: Mladen Gogala <mgogala@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 20 Dec 2006 09:16:43 -0500

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

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


Other related posts: