Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE Uses all the RAM.

VJ4Oct 27 2010 — edited Oct 28 2010

Hello ,
I have ORACLE DATABASE 10g R2 on Windows Server 2008 64-bit.

Now a days it is using all the Physical Memory in it which is 10GB. Then the whole system as well as the clients connected get very slow or they get disconnected.

I have nearly *350-400 session* on my database*. I can see in the task manager that the RAM is constantly increasing & reaches the max limit.*

In AWR report which i got from EM Console , it says that CPU usage is very high , but in task manager of windows sever 2008 64bit its hows CPU usage as 30-40% , which is quite okay , but RAM is getting FULL & creating the problem

What to do in such scenario ?? Please let me know some solution or let me know in which direction to focus ...

Thanks in advance ......

This post has been answered by Oviwan on Oct 27 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2010

Added on Oct 27 2010

#general-database-discussions

34 comments

2,446 views