Oracle: out of process memory when trying to allocate string bytes

Asked By ariel chu 20 points N/A Posted on - 04/13/2012

Out of a sudden, I get this error: out of process memory when trying to allocate string bytes problem in one of my client's oracle database. Is this normal? If not, what can I do to prevent it?

• Status: Open
• Question Views: 1816
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Harold kenosi

Go To Solution

Best Answer

Best Answer

Answered By Harold kenosi 5 points N/A #109757

Oracle: out of process memory when trying to allocate string bytes

 

Dear friend

• When oracle cannot get RAM needed to complete the operation it generates error “out of process memory” 
• Short PGA or kernel parameters are not set large enough to use RAM also cause this problem.
• Depending on the release of oracle that you are using there are several options to solve this problem.
• Increase pga_aggregate_target
• Decrease sort_area_size and/or hash_area_size
• Move to multi-threaded server
• Set the Kernel Param setting as below to solve this issue
• We changed the setting of “ulimit” as follows to resolve the issue:
• ulimit –a 
  time(seconds) unlimited 
  file(blocks) unlimited 
  data(kbytes) unlimited 
  stack(kbytes) 4194302 
  memory(kbytes) unlimited 
  coredump(blocks) unlimited 
  nofiles(descriptors) 4096 
• Above is also a part of oracle pre-install process.

About Harold kenosi

Questions
3

Answers
36

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 04/19/2012
• Question Category: Oracle Database

Answered By Karla Mahamad 0 points N/A #195593

Oracle: out of process memory when trying to allocate string bytes

Hello,

I believe you must check the memory on all nodes using the command given below.

ipcs –a

You can try to free the memory of the nodes by terminating oraagent.bin. This is not a permanent solution but it works fine for me. This might happen again but when an instance goes down it will not pop up again.

I hope this information will help you in resolving the problem you are encountering.

About Karla Mahamad

Questions
0

Answers
100

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 11/20/2013
• Question Category: Oracle Database