SAP/Oracle Database Monitor

You can use the SAP/Oracle database monitor in the DBA Cockpit to monitor your database running with Oracle 9i or Oracle 9i Real Application Cluster (RAC) or later. It is an expert tool.

Note Note

The documentation in this section refers to the new SAP/Oracle Database Monitor.

For more information on the old SAP/Oracle Database Monitor, based on ST04N, see SAP/Oracle Database Monitor (Old).

End of the note.

Integration

The database monitor is part of the Computing Center Management System (CCMS). You can start it from the DBA Cockpit.

The monitor obtains information from the Oracle performance views (V$, GV$, and DBA-views).

Prerequisites

To generate history information for the monitor, you must have planned the jobs RSORAHIST or RSORAHCL using transaction SM36.

To display full historical information, you must not have restarted the database during the relevant period.

You need to apply SAP Note 706927 before using the database monitor.

Features

The monitor:

Gives a general overview of database performance
Provides different ways of looking at the monitoring information:
- A main monitor with an overview of the database
- Detailed analyses using sub-monitors, grouped as follows:
Fully supports Oracle Real Application Cluster (RAC)
Does not support Multiple Components in One Database (MCOD)

Activities

Start the database monitor from the DBA Cockpit by choosing Performance Performance Overview .

Note

The following steps are generally valid for all screens, including screens in the sub-monitors.

End of the note.
If your SAP system uses Oracle RAC, in DB Instances you double-click the required RAC instance or Total for all RAC instances.
To see monitoring information for a specific history period, in Selected History you double-click Since and Up to and set them as required.
For more information, see Viewing History Information.
To refresh the display, choose Refresh.