| ORA-04030: out of process memory [message #311468] |
Fri, 04 April 2008 10:20  |
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  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
