RE: Oracle on windows 2003 on vmware
- From: "Carlson, Todd" <tcarlson@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Jan 2007 15:23:47 -0600
We looked into Oracle on VMware and came to the conclusion that it
wasn't a good idea for performance reasons. VMware adds an additional
and slow IO layer between oracle and the platters: VMware -> OS -> LVM
-> Disk. As a result, IO performance is not good. We do use this setup
for development and test databases where performance is not important.
HIH,
Todd
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Wednesday, January 03, 2007 2:43 PM
To: RROGERS@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle on windows 2003 on vmware
Not sure about that - never ran Oracle on vmware before, but I wouldn't
think it should require anything special. It sounds like the I/O to
your SAN is just slower than the I/O to the internal disks, but you
should run a 10046 trace (with waits) on both environments to confirm if
that's really where the bottleneck is. Verify that both queries are
using exactly the same explain plan first and then check the wait times
for the db file scattered reads and also your average read times in
v$filestat and/or statspack/AWR.
You could also just bypass the database and check the I/O speed at the
OS levels, e.g. by seeing how long it takes to copy a 500MB file or
something like that.
Regards,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.
Other related posts:
