Before considering where to place Oracle workloads on a cloud platform, ensure your VM container is rightsized. A workload’s performance profile should be collected over a sufficient period of time to reflect applications spikes in resource utilizations. While defining the required time range to collect time series data, consult with DBAs and application owners to understand the workload profile. At least a full month of “non-rolled up” time series data is recommended prior to execute the performance analysis.
Utilizing Blue Medora Oracle management pack with vRealize® Operations Manager™ is proven to be very helpful in this preparation phase. While analyzing captured data, make sure your rightsizing approach has been agreed upon by administrators, applications owners and business owners, and that it comprehends both spikes (high performance) and average utilization (higher density).
The following should be considered while sizing Oracle workloads: