Monitoring Performance

Performance Manager

In Oracle Enterprise Manager, the Performance Manager allows database administrators to monitor database performance in real time. You can use it to record statistics about OLAP Services, as well as the RDBMS and the operating system. Then you can display these statistics in a variety of formats, including tables, strip charts, horizontal and vertical bar charts, and pie charts.

Performance Manager is fully integrated with Oracle Capacity Planner, so that you can drill down on previously collected historical data. Using Capacity Planner, you can perform trend analysis on historical data to help predict your future requirements.

Configuration requirements

Oracle Performance Manager is a component of the Oracle Enterprise Manager Diagnostics Pack.

Oracle Intelligent Agent must be installed on the same computer as OLAP Services. The Intelligent Agent is installed with the Oracle RDBMS, so if OLAP Services is on the same computer as the database, then the Intelligent Agent is already available. However, if OLAP Services is installed on a separate computer, then you must install the Intelligent Agent. The Intelligent Agent runs as a daemon on Unix.

OLAP Services must be configured with the Data Gatherer module included in the module list. This is the default configuration. Additional configuration steps may be required. Check the README file for details.

Global counters

Global counters are preprogrammed into OLAP Services and collect data that apply to the service as a whole rather than individual sessions. You can use these counters to monitor usage patterns over time. These counters are loaded dynamically at runtime.

User counters

If your applications execute DML programs, then you can create and set your own counters. Like the global counters, these user counters can be viewed through Performance Manager. For more information about creating user counters, search OLAP DML Help for DGCART.

Procedure: Viewing charts

Follow these steps to view a chart of statistics for OLAP Services:

1. Open Performance Manager.

2. Log into Oracle Management Server if you want to save your statistics for further analysis. You can connect in Standalone mode, but you will not have access to those features that require a repository.

   You see the main Performance Manager screen.

3. Click the + next to OLAP Services.

   You see the OLAP Services Login dialog box.

4. Type in the following information, then click OK:
   • User name and Password: Your credentials for administering OLAP Services.

   • OLAP Services Instance: The name of the OLAP Services instance, such as OlapSrv900.

   • Collection Cartridge Location: The name of the computer where the collection cartridges are running.

   The OLAP Services node expands to show you the available counters.

5. To monitor a different instance of OLAP Services, redisplay the OLAP Services Login dialog box. From the File menu, choose Set Collection Cartridge Location.

   OLAP Services

6. Use the facilities of Performance Manager to gather and display statistics about OLAP Services. Click Help for detailed information.