High memory usage for Oracle on Windows 64 BIT

[Chucks_k]

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

[Chucks_k]

Any one have any thoughts on this?

[vnktummala]

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,

[Chucks_k]

Hi

Thanks for your response.

We did try a reboot but memory has shot up again.

[vnktummala]

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,

[PAVB]

Any one have any thoughts on this?

Since issue appears to be O/S related I would open a case with Microsoft.