-
Hello,
when i was trying to execute a packaged procedure, I got the error ora:4030-out of process memory. How can I increase the private process memory for a session.
-
Error: ORA 4030
Text: out of process memory when trying to allocate %s bytes (%s,%s)
-------------------------------------------------------------------------------
Cause: Operating system process private memory has been exhausted
Action: See the database administrator or operating system administrator to
increase process memory quota. There may be a bug in the application
that causes excessive allocations of process memory space.
*** Important: The notes below are for experienced users - See [NOTE:22080.1]
Explanation:
The Oracle shadow process cannot allocate memory. The error
should show the number of bytes being requested and area where
they are required
Diagnosis:
1) Check for a subsequent error, Eg: ORA 7324, to see where
memory is being allocated.
2) Check user memory limits and swap space. If these are too
low you may get the above error.
Eg: 'limit' or 'ulimit -a' on Unix.
3) It may help to reduce <Parameter:SORT_AREA_SIZE> if this is large.
4) Check if using the Parallel Query Option - if an operation is
being performed in parallel the memory requirements are greater.
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|