DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora:4030

  1. #1
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  3. #3
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Thanx a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width