Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: How to Rectify ORA-4030, How to rectify ORA-4031

  1. #1

    Smile How to Rectify ORA-4030, How to rectify ORA-4031

    Ora 4030

    This error comes as out of process memory when we trying to allocate 'n' bytes. whereby Oracle cannot get the RAM needed to complete the operations.*

    This ORA-4030 can be caused by a shortage of RAM on a dedicated environment, a too small PGA, and by not setting kernel parameters large enough to allow enough RAM. The ORA-04030 is also common when running an import.

    A) from the PGA Perspective

    To solve this error-
    Increase pga_aggregate_target
    Decrease sort_area_size or hash_area_size

    This error indicates that the oracle server process is unable to allocate more memory from the operating system. The error thus indicates the process needs more memory (stack UGA or PGA) to perform its job.

    B) Check User OS Limits

    Check the ulimits of the oracle user / user who is running the database using
    ulimt -Sa
    ulimit -Ha

    It can be a problem with the heap / stack size available to the oracle user from the OS side.
    If hard limits need to be increased , the same will need to be changed by root user in limits.conf
    Last edited by Hemant; 10-31-2011 at 05:59 PM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India
    Thanks Amit for this useful information

+ Reply to Thread

Similar Threads

  1. Rectify Worker Hanging / Patch Hang scenario
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 3
    Last Post: 02-03-2012, 06:37 PM
  2. Rectify REP-3000 Oracle Toolkit Error
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 2
    Last Post: 11-07-2011, 10:38 PM
  3. Rectify Worker Hanging / Patch Hang scenario
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 11-01-2011, 07:50 PM

Tags for this Thread

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics