First, we do not recommend that you run your production system Oracle database on the VMware vSphere4 platform, because the database running on VMware vSphere4 is certainly slower than the database running on the physical machine. If you really want to run the Oracle database, I personally have some suggestions, especially for users who have been connecting the database client for a longer time.
1. The Oracle database must be installed on a 64-bit OS. Because VMware vSphere4 has better performance based on 64-bit OS, running the database on a 32-bit OS may affect the performance.
2. Check whether the OS with Oracle database is migrated from the physical machine. If so, delete the hardware drivers on the physical machine. Of course, the best way is to install a new system.
3. When allocating vCPU to VMware vSphere4 virtual machine, we recommend that you allocate dual number. The test dual number is more efficient than the single number.
4. We recommend that you use sufficient CPU and memory for allocation.
5. Install VMware Tools and change the virtual Nic to vmxnet3.
6. It is recommended that the number of virtual machines on which the VM to which the database is installed should not be too large.
7. It is recommended that the physical Nic of the VMware vSphere host be directly connected to a Gigabit Switch instead of a 10-Gigabit switch.
8. We recommend that you upgrade to VMware vSphere5 immediately.
9. Database optimization everyone on the Earth knows that it is necessary to optimize databases on virtual machines or physical machines in order to maximize utilization.
I don't know if these are helpful to you. If you have any shortcomings, I 'd like to give you more advice.
This article is from the "bright tonight" blog