ORA-04030: out of process memory when trying to allocate 16384 bytes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-04030: out of process memory when trying to allocate 16384 bytes

  1. #1
    Join Date
    Sep 2000
    Posts
    17
    * * * * 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
    Location
    greenwich.ct.us
    Posts
    9,092
    You may be running out of physical memory. Make sure your sort_area_size is not too large.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2001
    Posts
    8
    Hi,

    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