-
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.
-
You may be running out of physical memory. Make sure your sort_area_size is not too large.
Jeff Hunter
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|