Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle on windows 2003 on vmware

RE: Oracle on windows 2003 on vmware

From: Kerber, Andrew <Andrew.Kerber_at_umb.com>
Date: Wed, 3 Jan 2007 15:41:41 -0600
Message-ID: <D40740337A3B524FA81DB598D2D7EBB305776FE1@x6009a.umb.corp.umb.com>


Yeah, my advice is don't do it. Linux to Windows? Is this guy a MS employee perhaps?  

Andrew W. Kerber
Oracle DBA
UMB     "If at first you dont succeed, dont take up skydiving"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ron Rogers Sent: Wednesday, January 03, 2007 2:28 PM To: oracle-l_at_freelists.org
Subject: Oracle on windows 2003 on vmware  

List,

Our corporate wiz kid has decided to migrate our Oracle 10g database from Linux to Windows2003 on Vmware.

Are there any special setup instruction needed to make this work properly? Any references that I might have missed? I searched the OTN but did not find anything that jumped out at me.  

Linux server. 1 CPU, 4 GIG ram, 3 internal mount points for data. Oracle setup with 1.6 GIG SGA  

Windows VMWARE server. 1 CPU, 4 GIG ram, 3 mount points on SAN(2 fiber channel 1 SATA) data. Oracle setup with 1.6 GIG SGA  

Both servers have the same tables, partitions, and data loaded on one mount point. In the Windows case it is the SATA SAN.

I set timing on.

I run the query select count(*) from a table that has 500,000,000 records and

 Linux = 4 min, 24.83 seconds

Windows = 19 min,53.19 seconds  

The results are proportionatly the same for the other tables that have millions of records.  

Is there any helpful hints that we might have missed when we set up the VMWARE ESX server for windows/oracle?  

When I google for VMWARE and Oracle the results are for Linux and RAC not windows. Maybe they are trying to tell me something.  

Any usefull suggestions?

Thanks,

Ron Rogers

DBA Georgia Lottery Corp.

404-215-5072


The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.



NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 03 2007 - 15:41:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US