Amazing is the only word to describe the performance of Oracle runing
on VmWare ESX.
The environment:
Physical
Dell Quad Core, 16GB RAM, clock 3GB
Storage: Hitachi
Virtual:
1 CPU 3GB RAM, 2GHZ
4 Luns
Windows 2003, Oracle 10g
I did this query to put the machine to work hard.
SQL> select count(*) from dba_objects t1,dba_objects;
COUNT(*)
———-
2474465536
Elapsed: 00:02:8.21
But as we can see, it was not hard enought.
Then the unbelievable part:
We started the query again AND we started the VMotion (The Vmotion duration: 1 minute)
But the Oracle lost just 12 seconds.
SQL> select count(*) from dba_objects t1,dba_objects;
COUNT(*)
———-
2474465536
Elapsed: 00:02:20.76
SQL>
Now we are testing 15 instances, with no kind of trouble.
The article below will help you to understand why it run so good