Oracle on VMWare

Recommendations from VMWare (dated 2013 - TODO: are these still valid?)

Memory - NUMA

• Disable NUMA in DB–Poor Implementation

• Set vSockets=1– Try to keep Database VMs on the fewest sockets–Improve NUMA.

• Use preferHT–VM prefers local hyper threads on same core when vCPUs exceed the number of cores in the socket.

Memory - Reservations

• Utilize Memory Reservation–Size of the SGA + 2 times Aggregate PGA Target + 500MB for the OS (assuming some flavor of Linux).

• These should be for Production Clusters only, as Development and Test databases do not usually require peak performance.

Network - Dynamic Coalescing (RAC)

• Set EthernetX.coalesceScheme = ‘disabled’ in the .vmx file (especially for the interconnect network card)

Network - Latency

• Set the Interrupt rate on Network Adapter to 30K

CPU

• Set the number of vCPUs to the number of active foreground sessions in the database.

Oracle on Docker