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

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: