-
High memory usage for Oracle on Windows 64 BIT
Hi all,
OS: Windows 2003 64 Bit Physical mem is 12GB and 4 CPU's
DB: 10204
Our SGA (and sga_max_size) is sized at 8GB and PGA_AGGREGATE_TARGET is sized at 2GB. On task manager we see that the mem usage col is at 2GB and peaked at 3GB howver the VM Mem size is 15GB. On task manager we see that memory usage is consistently at 97%. We have had several processes falling over because the memory usage topped out at 100%. We want to know why task manager is showing 15GB even though physical memory on the box is 12GB and also identify what is causing the high memory usage? We investigated by EM and ash reports and saw that there is an advanced queueing job which is taking up roughly 45% of the DB time and it is running consistently also the correspond oracle is session is listed at the top session in the DB. However, I am not sure if this is the actual culprit or we have a bug/memory leak in our hands. Also large page support has been enabled, can this have an adverse effect on memory usage? Users have no reported any perfomance problems.
Thanks in advance
Chucks
-
Any one have any thoughts on this?
-
honestly, I never heard about memory leak issues in windows servers. This could be the generic issue in great windowz which will clear after a server bounce.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Hi
Thanks for your response.
We did try a reboot but memory has shot up again.
-
most of the times these kind of issues will go off by doing 3 things.
1. restart
2. windows update
3. cleaning up spy / mall ware
as you have already done with 1, please check with your system admin and make sure you have recent windows updates installed and no spy ware is running in the server.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by Chucks_k
Any one have any thoughts on this?
Since issue appears to be O/S related I would open a case with Microsoft.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|