Home » Server Options » Replication » ORA-04030: out of process memory (Oracle 9i, Unix)
ORA-04030: out of process memory [message #311468] Fri, 04 April 2008 10:20 Go to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
Hi Guys,
Actually i created a materialized view, and whenever i try to refresh data, using the following package(dbms_mview.refresh
), im getting the ORA-04030 error

ORA-12008: error in materialized view refresh path
ORA-04030: out of process memory when trying to allocate 1052696 bytes (callheap,kllcqas:kllsltba)


As far as i know, there no shortage of ram in this machine, im not sure what is causing this error,

Then i tried to do a bulk insert using a "INSERT /*+ APPEND */ "
in a package, when i execute it, im getting the same error again.

exec M_GET_FACILITIES_DETAILS.GET_AUTOFINANCE_HP_DETAILS('29-Feb-2008');

ORA-04030: out of process memory when trying to allocate 1052696 bytes (callheap,kllcqas:kllsltba)

The number of records im trying to insert is around 600,000, but if i try to repeat the same process with 50000 records, it works fine. i

Actually is there any oracle parameter i need to change, cause im afraid if i do that, later in production, it might effect some other modules
thanks for any advice

[Updated on: Fri, 04 April 2008 10:23]

Report message to a moderator

Re: ORA-04030: out of process memory [message #311472 is a reply to message #311468] Fri, 04 April 2008 10:32 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
Cause: Operating system process private memory has been exhausted
Action: none

It depends on the OS and Oracle can't do nothing.
Check if you can't allocate more memory to user (ulimit -a).
Otherwise check if you can't take less memory.

Regards
Michel
Previous Topic: Could not create Materialized view with refresh fast on commit
Next Topic: Materialized view
Goto Forum:
  


Current Time: Sat Dec 10 03:16:09 CST 2016

Total time taken to generate the page: 0.08443 seconds