Home » RDBMS Server » Server Administration » out of process memory
out of process memory [message #52525] Sat, 27 July 2002 23:46 Go to next message
kudrath
Messages: 1
Registered: July 2002
Junior Member
Iam wowrking on parallel server os/Nt server with oracle 8i enterprise editon.
This error is coming frequently
'OUT OF PROCESS MEMORY WHEN TRYING TO ALLOCATE 197120 bytes(CURSOR WORK HE,kkcqas:kllsltba)
I already reduced the shared pool size but still it is giving problem

Report message to a moderator

Re: out of process memory [message #52528 is a reply to message #52525] Sun, 28 July 2002 10:27 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
1. increase the virtual memory 
2. You may also try decreasing the parameters like
   sort_area_size , bitmap_merge_area_size ,
   create_bitmap_area_size . 
3. You can also free up the unused PGA memory by
   running the procedure
   dbms_session.free_unused_user_memory.. 
4. check for the subsequent erros? (ora-7324)
5. if using the Parallel Query Option - if an
   operation is being performed in parallel the memory
   requirements are greater.

Report message to a moderator

Previous Topic: How to recover from a lost RBS datafile.
Next Topic: ora-01579
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 06:53:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.