I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM.
It works pretty well after the database is initialized, but after some time it starts slowing down. I've tried to run statistics, rebuild all indexes, export and reimport the dump file, uninstalling/reinstalling Oracle, increase the sga size.. but none of these worked so far. The strangest thing is that if I import this dump into a virtual machine running Microsoft Windows Server STANDARD 2003 with 4GB RAM it works perfect without any performance issue.
Question: Is there a different configuration that must be done on Oracle or on Windows Server Enterprise 2003 to avoid this problem? I'm a not a DBA, so my point of view is that the machine with 8GB should run better than the other one, am I right?
Thanks in advance.