Home » RDBMS Server » Server Administration » ORA-04030: out of process memory
ORA-04030: out of process memory [message #196845] Sun, 08 October 2006 07:53 Go to next message
arsheshadri
Messages: 12
Registered: January 2006
Junior Member
Hi,

We are getting
"ORA-04030: out of process memory when trying to allocate 61464 bytes (QERHJ hash-joi,kllcqas:kllsltba)
ORA-06512: at "SFRTTCS.PROCESS_NEW_APPLICATION", line 476
ORA-06512: at line 1"
in our database while performing some tests.

Our database is running on AIX-Based Systems (64-bit) and
the database version is 10.1.0.4.0.

Our RAM size is 6GB.

Following are some of the parameters set on the database.

sga_max_size = 3G
sga_target = 3G
statistics_level = TYPICAL
pga_aggregate_target = 2G
workarea_size_policy = AUTO
shared_servers=1
Processes = 500

The error always comes for SFRTTCS.PROCESS_NEW_APPLICATION procedure.
Can you please suggest any changes in db settings?

Thanks & Regards
Sheshadri
Re: ORA-04030: out of process memory [message #196846 is a reply to message #196845] Sun, 08 October 2006 08:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems like the bug 4877068.
Consult metalink and raise a TAR.
Re: ORA-04030: out of process memory [message #196852 is a reply to message #196845] Sun, 08 October 2006 11:10 Go to previous messageGo to next message
chkd
Messages: 7
Registered: April 2006
Junior Member
you have to set setting to unlimited to oracle user like below. this is operating system setting not database setting.

if you have root priviliege, you smit user and change setting or Oracle user. otherwise, ask your system administrator to do it for you.

>ulimit -aH
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) unlimited
Re: ORA-04030: out of process memory [message #196855 is a reply to message #196846] Sun, 08 October 2006 11:34 Go to previous messageGo to next message
arsheshadri
Messages: 12
Registered: January 2006
Junior Member
Hi,

Thanks for your advice. My current settings are as follows.

$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000

Do you think I need to change any other settings.

Thanks & Regards
Sheshadri
Re: ORA-04030: out of process memory [message #196893 is a reply to message #196855] Mon, 09 October 2006 01:23 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

As mentioned "Mahesh" it is bug. plz. consult Metalink for more help.
Re: ORA-04030: out of process memory [message #276376 is a reply to message #196845] Thu, 25 October 2007 01:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I don't think O
Quote:

RA-04030: out of process memory when trying to allocate 61464 bytes (QERHJ hash-joi,kllcqas:kllsltba)
is a bug 4877068. Bug 4877068 applies to Windows machine. But I have solaris computer and get the same message.

My configuration is,

core file size        (blocks, -c) unlimited
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
open files                    (-n) 256
pipe size          (512 bytes, -p) 10
stack size            (kbytes, -s) 8192
cpu time             (seconds, -t) unlimited
max user processes            (-u) 29995
virtual memory        (kbytes, -v) unlimited

Total System Global Area 2550136832 bytes
Fixed Size                  2031072 bytes
Variable Size            1375732256 bytes
Database Buffers         1157627904 bytes
Redo Buffers               14745600 bytes

pga_aggregate_target = 1G
sga_target=2432M
sga_max_size=2432M


Any suggestion?

The matalink note https://metalink.oracle.com/metalink/plsql/f?p=130:14:2536506163093105830::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,233869.1,1,1,1,helvetica
does not helped me.
Re: ORA-04030: out of process memory [message #276393 is a reply to message #276376] Thu, 25 October 2007 01:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi Arju,
Did you check ?

https://metalink.oracle.com/metalink/plsql/f?p=130:14:11021149988255368775::::p14_database_id,p14_docid,p14_show_header,p14_show_help ,p14_black_frame,p14_font:NOT,233869.1,1,1,1,helvetica


Re: ORA-04030: out of process memory [message #276394 is a reply to message #196845] Thu, 25 October 2007 01:43 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yes, I specified this link in my post and it did not help me. Everything seems ok in my system according to this link , I also gave a sample of my configuration.

But error still remaining.
Re: ORA-04030: out of process memory [message #276481 is a reply to message #196845] Thu, 25 October 2007 04:55 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

According to metalink note,
https://metalink.oracle.com/metalink/plsql/f?p=130:14:2536506163093105830::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,199746.1,1,1,1,helvetica
it seems to me there may be oracle product defects.

Version 10.2.0.2 on solaris 64 bit.
Previous Topic: How release space on tablespace PERFSTAT
Next Topic: How to increase dba_free_space
Goto Forum:
  


Current Time: Tue Dec 06 02:29:53 CST 2016

Total time taken to generate the page: 0.12298 seconds