Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-04030: out of process memory when trying to allocate 123952 bytes(callheap,temporary memory)

ORA-04030: out of process memory when trying to allocate 123952 bytes(callheap,temporary memory)

From: yarly <yrbabu_at_sify.com>
Date: 28 Aug 2002 06:42:39 -0700
Message-ID: <d8d54f1.0208280542.59e86241@posting.google.com>


Hi
We are running 32-bit Oracle 9.0.1.3 on Solaris 8 Our server is SUN E15K and we have 8GB RAM. The database is supporting an Oracle Applications 11i

When users are trying to manage people in GLOBAL HRMS, they are getting the following error.

FRM-40735: POST-UPDATE trigger raised unhandled exception ORA-04030.
--------------------------------------------------------------
ORA-04030: out of process memory when trying to allocate 123952 bytes
(callheap,temporary memory)
ORA-06512: at "APPS.HRENTMNT", line 5760
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 174
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 622

I have plenty of SWAP available. This is the output of swap -s command

total: 1369784k bytes allocated + 1038880k reserved = 2408664k used, 11354640k available

My sort_area_size is 128K
My sort_area_retained_size is 0
I'am running in DEDICATED SERVER.

My SGA is

Total System Global Area 1582599088 bytes

Fixed Size                   281520 bytes
Variable Size            1258291200 bytes
Database Buffers          318767104 bytes
Redo Buffers                5259264 bytes


I tried reducing the sort_area_size.
I would appreciate any new ideas.
Thanks in advance
Yarly Received on Wed Aug 28 2002 - 08:42:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US