ORA-04030/ORA-01652 Out of process memory when trying to allocate

[Former Member]

Hi

I am facing a problem with two sap batch jobs and they failed all the time with follwoing ora errros:

We have started facing this problem just after upgrade from Oracle 9.2.0.7 to 10.2.0.4.

ABAP Dump: DBIF_RSQL_SQL_ERROR

Database error 4030 at FET access to table ORA-04030: out of process memory when trying to allocate

Database error 1652 at FET access to table ORA-01652: unable to extend temp segment by 256 in tablespac PSAPTEMP

OS = Windows 2000, SAP 4.7, Oracle: 10.2.0.4

RAM = 4 GB

Page memory = 14 GB

pga_aggregate_target=824288000 (Standard is 20% of Memory)

sort_area_size=2097152

PSAPTEMP= 6 GB

I have found that changing the setting of u201Culimitu201D as follows can resolve the issue:

ulimit u2013a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) 4194302

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) 4096

Question:

1. May I know what are the ulimit settings and how can i change them ?

2. Or It there any other wayout to solve the Error?

Regards - Ricky

[markus_doehr2]

Those are two different errors:

> Database error 4030 at FET access to table ORA-04030: out of process memory when trying to allocate

> OS = Windows 2000, SAP 4.7, Oracle: 10.2.0.4

> RAM = 4 GB

> Page memory = 14 GB

It seems you reach your 32bit imposed limit.

Check Note 789011 - FAQ: Oracle memory areas

it contains a special section what you can do (best would be to switch to 64bit).

> Database error 1652 at FET access to table ORA-01652: unable to extend temp segment by 256 in tablespac PSAPTEMP

Increase your temp tablespace.

"ulimit" is on Unix only.

Markus