OraFAQ Forum: Server Administration » ORA-04030: out of process memory

Home » RDBMS Server » Server Administration » ORA-04030: out of process memory

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04030: out of process memory [message #196845]

Sun, 08 October 2006 07:53

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

Report message to a moderator

Re: ORA-04030: out of process memory [message #196846 is a reply to message #196845]

Sun, 08 October 2006 08:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Seems like the bug 4877068.
Consult metalink and raise a TAR.

Report message to a moderator

Re: ORA-04030: out of process memory [message #196852 is a reply to message #196845]

Sun, 08 October 2006 11:10

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

Report message to a moderator

Re: ORA-04030: out of process memory [message #196855 is a reply to message #196846]

Sun, 08 October 2006 11:34

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

Report message to a moderator

Re: ORA-04030: out of process memory [message #196893 is a reply to message #196855]

Mon, 09 October 2006 01:23

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

As mentioned "Mahesh" it is bug. plz. consult Metalink for more help.

Report message to a moderator

Re: ORA-04030: out of process memory [message #276376 is a reply to message #196845]

Thu, 25 October 2007 01:11

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.

Report message to a moderator

Re: ORA-04030: out of process memory [message #276393 is a reply to message #276376]

Thu, 25 October 2007 01:41

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

Report message to a moderator

Re: ORA-04030: out of process memory [message #276394 is a reply to message #196845]

Thu, 25 October 2007 01:43

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.

Report message to a moderator

Re: ORA-04030: out of process memory [message #276481 is a reply to message #196845]

Thu, 25 October 2007 04:55

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.

Report message to a moderator

Previous Topic:	How release space on tablespace PERFSTAT
Next Topic:	How to increase dba_free_space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:24:02 CST 2024