Saturday, January 31, 2015

missing memory in Windows Server 2003 x64

We have Oracle database running on a 64-bit Windows Server 2003 Enterprise Edition, with 32GB RAM.




The database has been configured to use 10gb for SGA (target = max = 10GB) and 5GB for cache. Upon startup, the task manager would show around 12GB of free memory. On this server, the only application running is the database. During the day, we would see the free memory gone all the way down to 4MB.



We would like to find out what application is eating up the free memory. The memory usage does not add up on the task manager nor on perfmon. We suspect some process is taking up the free memory and not releasing it. How do we proceed?

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...