DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2000
    * * * * I need your help on this problem urgently. When i run a SQL query in Oracle on the Production Server, it is giving me this error. What should i do ?

    * * * * ERROR: SQL code, error message: -1 ORA-04030: out of process memory when trying to allocate 16384 bytes (sort subheap,sort key)

    * * * * This is happenning only on the Production Server. When i execute the same query on the SIT Server, it does not give me the above error and executes in a few seconds. I checked the SGA and other Oracle settings of both the servers and did not find any difference. Can you please help me out.

  2. #2
    Join Date
    Nov 2000
    You may be running out of physical memory. Make sure your sort_area_size is not too large.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2001

    Have you checked your kernel parameters. Are they the same for both the environments and set as per oracle's recommendations ?

    Sonal D'Souza.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.