This section focuses on the network configuration and its impact on database performance. These use cases explore the best practices of two networks for a single node Oracle database running a VM on ESXi host:
- vMotion Network: ESXi vMotion Network enables the live migration of running virtual machines from one ESXi host to another. vMotion time is an important performance metric that quantifies the time it takes to run virtual machines to migrate from one ESXi host to another ESXi host.
- Public network: The public network connects between applications and the database server. As applications connect to the database server through SQL * Net messages such as waits and the average latency depends on the public network. SQL * Net message performance can be found in the database AWR report.
Enable the Jumbo Frames by changing the maximum transmission unit (MTU) setting from 1500 to 9000 for both the vMotion network and public network. Jumbo Frames should be enabled end-to-end for all the devices on the same VLAN along the path.
To change the MTU settings:
- Login to vSphere
- Select ESXi host1
- Click the configure tab and select the VMkernel adapters
- Under VMkernbel adapters, select vmk1 (Motion network) and click Edit
Figure 21. Select vmk1 to Change MTU setting
- On the VMk1-Edit settings display page, change VMkernel port settings: MTU from 1500 to 9000
Figure 22. Change MTU from 1500 to 9000