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

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

Post by yarl » Thu, 29 Aug 2002 14:36:33



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
Ramesh

 
 
 

1. ORA-04030: out of process memory

...when trying to allocate x bytes.

Have created a database on 8.1.7.2 EE on HP-UX (11.0).
Adding JVM to new db and job crashes when it runs a JVM script called
jisja.sql (which turns on JAccelerator (ncomp) for JIS). Comment out this
script and rerun job and I get the same error (ORA-04030) at several other
points along the JVM job resulting in an
unsuccessful install of JVM against the db.

Searched Oracle Metalink and most refs found were for the initjvm.sql
scripts producing the
same error. Metalink solution was to check ulimit and up the memory
allocated to the
user. Have checked (as root) with ulimit -a and received the following
output:
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         65536
stack(kbytes)        8192
memory(kbytes)       unlimited
coredump(blocks)     4194303
nofiles(descriptors) 2048
However I am running the job as the Oracle user (oracle), who is a user on
the NIS, and try
to get the same info with ulimit -a and it gives me "ksh: ulimit: bad
option(s)". When I try
'ulimit' (with no args) I get "4194303" which I take to be the
coredump(blocks) output similar
to what was given for roots' ulimit -a. All docs found give advice to
increase the memory
for this user (oracle). How is this done? I have tried "ulimit -m unlimited"
as the oracle user
with the error "ksh: ulimit: bad option(s)".

Or am I totally in the wrong direction and its something other than the
ulimit thing?

Any help with this appreciated from either the Oracle or HP-UX groups.

Thanx in advance.
Rex

2. Help Needed: Visual Tools for Teaching OOP

3. ORA-04030 out of process memory

4. Bank Switching and 32bit

5. Error ORA-04031: unable to allocate 288 bytes of shared memory

6. Hiragana and Katakana fonts

7. ORA-04031 unable to allocate shared memory

8. ORA-04030

9. 4 Gb RAM Windows 2000 and Oracle 8.1.7 (ORA-04030)

10. ora-04030

11. ORA-04030 with PGA_AGGREGATE_TARGET

12. ORA - 04030