Windows 2003 Std. Ed. memory usage and manage

[MITELMX]

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!!

 

[itsp1965]

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

 

[MITELMX]

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.

 

[WhoKilledKenny]

For Enterprise Edition:

http://support.microsoft.com/kb/283037/