Managing the capacity of your Oracle databases

Excerpt named hoco_goals was not found in document xwiki:IT-Operations-Management.Continuous-Optimization.BMC-Helix-Capacity-Optimization.hco2002.Implementing.Managing-the-capacity-of-your-vSphere-infrastructure.WebHome.

As a Capacity Planner or Oracle Enterprise Manager (OEM) Specialist, you can use BMC Helix Capacity Optimization to configure, administer, and manage the capacity of your OEM Cloud Control solution.

As the flow diagram illustrates, the data source (OEM ETL) collects data from the OEM Cloud Control solution. The collected data is transferred to the Capacity Optimization data warehouse where it is processed, and then displayed on the user interface. You can use the product features to review, analyze, and manage the capacity of your OEM infrastructure.

The following sections describe how you can achieve these goals:

Manage the capacity of OEM infrastructure
Manage future demand

Managing the capacity of OEM infrastructure

You can analyze and manage the capacity of your OEM elements by using the Workspace. For the OEM data to be available for analysis, the Administrator must first set up the data source to collect data.

Step 1. Collect data

As an Administrator, configure and use the out-of-the-box Oracle Enterprise Manager extractor for data collection. The OEM ETL imports the following types of entities:

Host: database server and monitored server
Cluster
Database instance
Database rack
Automatic Storage Management (ASM) entities, such as instances and clusters

After data collection starts, data is loaded in the data warehouse daily and Indicators are available in the Workspace.

Step 2. Analyze the collected data

To perform analysis on the imported OEM data, such as identifying specific performance issues, trends, and bottlenecks, you can use Analysis.

About Analysis

An analysis is a visual tool that you can use to identify the behavior of a set of metrics and the relationships among them. Each analysis can focus on the business driver metrics of an application, on the performance of an application's systems, and on the events related to an application. Analyses can also be used to compare performance and business driver metrics to determine a system's behavior under load.

Here are some use cases for which you can create and use Analyses:

For more examples, see Creating-an-analysis.

Disk Activity of Database Instance
Memory Utilization of Database Servers

Analyze the disk activity of an OEM database instance over time

Analyze the memory utilization of OEM database servers and clusters

Managing future demand

By using the analysis charts, you can analyze the data of your existing capacity. Use Models to predict service performance and obtain forecasts of historical series of metrics, including deep details on the modeling techniques used in forecasts and how to interpret the results of model runs.

About models

A model is a simplified mathematical description of service components that evaluates historical data, predicts future behavior, and simulates what-if scenarios. Models are always built on existing data and analysis. After you create a model, define scenarios to perform multiple predictions under different conditions. With Models you can forecast and model changes in service demands.

How to determine when a resource of a database server completely saturates

For more information, see Modeling-capacity-usage