ORA-04030: out of process memory

From: Sriram Ramachandran <sriram_kr_2000_at_yahoo.com>
Date: Fri, 5 Nov 2004 11:36:39 -0800 (PST)
Message-ID: <20041105193639.52859.qmail@web51504.mail.yahoo.com>

We are on Apps 11i/DB 9.2.0.5 on Windows 2000 Advanced Server.

Recently i upgraded the database from 8.1.7.4 to 9.2.0.5 and i started seeing the following error message in the alert.log:-

Errors in file
f:\oracle\proddb\9.2.0\admin\prod_oradb\udump\prod_ora_2840.trc: ORA-04030: out of process memory when trying to allocate 917536 bytes (joxcx callheap,ioc_allocate ufree)

This usually happens when the memory usage exceeds 2.5GB. The machine is a 4 CPU, 4GB(with the /3GB switch turned on).

Oracle support suggests that i use orastack to modify the default stack size of a thread/session.

Currently it is set as follows:-

Current Reserved Memory per Thread = 1048576 Current Committed Memory per Thread = 4096

I'm planning to reduce it to 500K.

Has anyone tried changing the default stack size on 9i and what are your experiences? Metalink note: 46001.1 has the details for orastack.

Thanks,
Sriram

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Fri Nov 05 2004 - 13:32:34 CST