Oracle Logbook

April 29, 2008

Oracle on Vmware

Filed under: Uncategorized — heliodias @ 6:37 pm

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

Ten Reasons Why Oracle Databases Run Best on VMWare

Blog at WordPress.com.