OraFAQ Forum: Server Administration » out of process memory

Home » RDBMS Server » Server Administration » out of process memory

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

out of process memory [message #52525]

Sat, 27 July 2002 23:46

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

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:11:44 CDT 2024