Managing the capacity of your Oracle databases

As a Capacity Planner or Oracle Enterprise Manager (OEM) Specialist, you can use BMC Helix Continuous 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 Continuous Optimization 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.

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

The following sections describe how you can achieve these goals:

Manage the capacity of OEM infrastructure
Perform advanced analysis
Manage future demand

Collecting the data of OEM infrastructure

You can analyze and manage the capacity of your OEM elements from the Workspace tab. For the OEM data to be available for analysis, the Administrator must first set up the data source to 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 daily and Indicators are available in the Workspace tab.

Performing advanced analysis

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

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

InformationThese videos describe the functionality of TrueSight Capacity Optimization, but they are valid for BMC Helix Continuous Optimization too.

Analyze the disk activity

The following video explains how to create an analysis to analyze the disk activity of an OEM database instance over time.

Analyze the memory utilization

The following video explains how to create an analysis to analyze the memory utilization of OEM database servers and clusters.

For more information, see Creating-an-analysis.

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.

Forecast the saturation of a resource

The following video explains how to create a model to predict when a resource of a database server saturates completely.

Information

This video describes the functionality of TrueSight Capacity Optimization, but it is valid for BMC Helix Continuous Optimization too.

For more information, see Modeling-capacity-usage.