Question

Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit

Windows Server 2003, Oracle 9i

We have procured an application for archiving of reports. Initially we were suggested to go for Windows 2003 ENterprise edition 32 bit (R2) with Oracle 9i 32 bit. After about 1 year of rolling out, we found that application became very slow. To enhance the room for memory, we went for memory upgrade from 4GB to 16GB on vendor's advise.

Now we find that problem still remains.

My question is

a) Whether Oracle 9i 32 bit is capable of recognizing 16GB RAM
If yes, what are tuning steps
b) Whether Windows 2003 Datacentre edition requires any tuning to make use of 16GB RAM

Please share your experience, so that we can work to stabilize the project.

Check if 16GB RAM is recognized by your server with Win2003 in ‘properties’. if it does not, check with server specs how much maximum RAM it can support.

If it supports 16GB and the performance is ditto same as was with 4GB, take a backup of your database, reinstall OS and Oracle 9i and restore your backup. It will solve your issue.

----------

Windows 2003 Enterprise Edition will support 16 gigs of RAM without a problem. Windows 2003 Datacenter edition is not required until you want to use over 64 Gigs of RAM.