Home > Solution Categories > Database > Oracle Database > Oracle: out of process memory when trying to allocate string bytes
Question
No of visitors who read this post: 546
Category: Oracle Database
Type: Question
Author: Ariel chu
No votes yet

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?

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Submitted by Harold kenosi on Thu, 2012-04-19 18:21. Comment Id: 55281

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.
Previous Previous Page
97 of 234
Next Page Next