|Oracle9i OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)
Part Number A88755-01
Tuning, 5 of 5
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.
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 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.
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.
Follow these steps to view a chart of statistics for OLAP Services:
You see the main Performance Manager screen.
+next to OLAP Services.
You see the OLAP Services Login dialog box.
The OLAP Services node expands to show you the available counters.