I have two Windows Server 2003 64-Bit servers running Oracle 10g databases in a clustered environment. Recently we have noticed that access to these databases via their front-end applications is being denied. Database logs on the server show THS:125xxx errors due to "out of memory" messages. So, the database is refusing incoming connections.
My DBAs noticed that the Page File size increases gradually with the increase of database processes on the server. They also noticed that the O/S retains the Page File size instead of releasing the memory used by the processes after they are completed.
So we are looking for methods to configure the O/S to release the Page File when it is done using it for needed processes or even if there is a way to do so.
Thanks!!!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
As long as the page file isn't growing without bound, you should not be concerned. It should reach a point of balance.
As schwertner says, use a tool to investigate, if you are seeing infinite growth.
The only problem is the paging itself. If, within normal running, you see too much paging, you need more RAM, or need to detune some of the PGA / SGA stats, or shutdown other stuff.
I had a similar issue with our backup software while backing up to disk on Windows Server 2003 64 bit. Here is what worked for us. Add a DWROD registry entry called PoolUsageMaximum in HKLM\SYSTEM\CurrentControl
http://support.microsoft.c
angelIII,
The root cause here is "out of memory" so don't you feel the suggestions, such as add more RAM, or decrease SGA are reasonable suggestions? Since the asker never posted back, I won't object if you strongly disagree to the PAQ value of the question, but in my experience, any out of memory errors are caused by either a memory leak, or insufficient RAM, but most often, by the latter, and even in the case of the memory leak, adding more RAM will prolong the runtime. With Oracle, I doubt the issue is a memory leak.
mjc
Business Accounts
Answer for Membership
by: schwertnerPosted on 2009-06-02 at 12:16:21ID: 24530389
This is normal for every server OS.
They use the unused memory in the RAM to cache disk blocks, processes, etc.
but releases the occupied place on demand.
We experienced the same phenomena and were in the same state of panic (we suspect memory leaks, etc.). But this is normal.
To investigate the case use a tool (like xosview in Linux) that will report the used memory, the cache zone and the unused memory.