Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Windows 2003 Std. Ed. memory usage and manage

Status
Not open for further replies.

MITELMX

Technical User
Jul 12, 2005
66
CA
Hi everyone,

Currently i have a windows 2003 server, standard edition with a Oracle installed on it, my problem at the moment is regarding with the memory, i can not improve the performance of the Database connection because 4 Gb of 8 Gb that i have installed is used for the application and 1 Gb more that is using by Windows,finally i only have 3 Gb using by the ORACLE. My question is, if exist some way to give more memory to ORACLE or the applications? i have tried already to increase the page file but i am still having the same problem. I need from you your best practice, i also intented all that it's on google and it's the same issue.

i hope you can help me to find out a great solution.

My best regards!!
 
Windows 2003 Std Edition supports 4GB RAM max. If you need greater memory support, you should upgrade to Enterprise Edition which supports up to 64GB.
Within the first 4GB usually the OS requires 2GB leaving 2GB for applications. Setting a larger pagefile may help you in the short term in regards to running out of resources, but you are paging more and more to disk thus affecting performance
Upgrading your Windows OS/memory will allow you to use the memory above the 4GB mark by using PAE extensions, from there you can tweak the memory config for Oracle (in SQL Server you use AWE)
Hope this helps
 
Hi itsp1965,

Ok,but now i have enterprise ed. with 8 gb in Ram, What can i do to use more than 4 GB for applications, because if i checked the memory usage i only use 4 and not 8.


Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top