[Last Call] Learn how to a build a cloud-first strategyRegister Now



Posted on 2012-09-14
Medium Priority
Last Modified: 2016-11-23
I have a question on how a virtual machine file is stored and how oracle is stored when installing on the virtual machine.

If i have a dell machine with 8 physical disks configured as raid10 (array has 8 disks)

When sys admin creates a Virtual machine (VMware ESX) a file is created for that machine.

I assume the file is located on one of the 8 disks.

If i install oracle to the virtual machine does not that mean all the files and databases will be created within that VM file which means on one disk which is not good for database performance. I  would like to install system software on one disk, databases on second disk, and backup areas and archive file on 3rd disk..

When you nornally create a virtual machine do you specify different disks for the VM file?
Question by:sam15
  • 3
  • 2
  • 2
LVL 124

Accepted Solution

Andrew Hancock (VMware vExpert / EE MVE^2) earned 1000 total points
ID: 38399176
the virtual disk (vmdk), which is created by the VMware Hypervisor, will be stored in the datastore, which will be stripped over your 8 physical disks configured as RAID 10.

the vmdk is not located on a single physical disk, VMware ESX does not detect 8 p[hysical disks, it's presented a RAID 10 datastore, which is a single "block" or RAID 10 storage.

it's correct, that when you install Oracle, all the files and database will be in that single file (vmdk). But...

the benefit is the virtual disk is stripped over eight disks which will increase performance.

But you can still if you like create three seperate disks, which will all be stored on the same datastore, but I do not think there will be any performance gain, because all three disks are on the same RAID 10 datastore, compared to a single virtual disk, with all the same data.

Author Comment

ID: 38399320
I think you mean striped over 4 disks since the other 4 are simply mirror disks.

So you are saying the the virtual datastore is really stored on the 4 physical disks.
Is this always automatic when you install a Virtual machine meaning it will always look for all the physical disks on the machine and create a virtual datastore on all disks?

It sounds when i install oracle, i dont really have an option other than selecting the virtual datastore for all directoires and files.
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 38399395
I think I mentioned this in your previous related questions:  I feel you are over-thinking this.

Think of it in layers:
Bottom layer:  Physical drives
On top of that you bind physical disks together to create logical devices.

You can then create one or more file systems on one or more logical devices.

Now you have Virtual machines on top of that.

So do you have 4 disks bound as one large device and mirrored or 8 disks bound together as raid 10?

However you have them bound:  When you create a file on disk, it must obey the filesystem it is on.  If that filesystem is on all 8 stripped/mirrored disks:  any file is also on those same disks.

The VM's VHD is just a file on disk.  It obeys the same rules.  If you create two VHDs on the same host filesystem, it will be on the exact same disks as any other file on the host file system so no real performance gains.

Now where you might benefit later is if you add additional disks to the host OS and create a different raid binding.  Then you can move the VMs VHD to the other raid binding and Oracle inside the VM can take advantage of the extra disks and there isn't anything to change inside the VM itself.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 38399431
I need to check with sys admin on the internal structure.
What do you mean by "bound"? is it a physical link.

So you can have 8 filesystems (one on each disk) or one fielssytem for all 8 disks?

Do you know of a good link with pictures that shows all of this. a picture is worth a thousand words.
LVL 124
ID: 38399653
it's best to have RAID10, with all disks in a single RAID 10.
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38399697
>>What do you mean by "bound"? is it a physical link.

More or less it is a physical link.  When you create a 'group' of physical disks for a RAID setup they are said to be 'bound' together.  This makes a logical device of more than one physical device.


Here is a decent description that hopefully will help you see the physical to logical device mapping:

>>So you can have 8 filesystems (one on each disk) or one fielssytem for all 8 disks?

Sort of.  A file system is just how the OS allocates space on a device:
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38399716
>>it's best to have RAID10, with all disks in a single RAID 10.

All things being equal, this is probably true.  However things are rarely ever equal.

The main one being administrative staff.  The 'safest' bet is RAID-5 if the systems using the disks can handle the write performance hit.  Since the disks in question will mainly handle smaller Oracle databases where raw performance isn't a main consideration RAID-5 would probably be fine here and a lot fewer headaches when a disk failure happens.

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question