SAP/Oracle Database Monitor (New)
Use
You can use the SAP/Oracle database monitor to monitor your database running with Oracle 9i or Oracle 9i Real Application Cluster (RAC) or later. It is an expert tool.
The documentation in this section refers to the new SAP/Oracle Database Monitor based on transaction ST04N.
For more information on the old SAP/Oracle Database Monitor, based on ST04, see SAP/Oracle Database Monitor (Old).
Integration
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, from which you can drill down to see more information
¡ Detailed analyses using submonitors, grouped as follows:
· Fully supports Oracle Real Application Cluster (RAC)
· Does not support Multiple Components in One Database (MCOD)
Activities
...
1. To start the monitor you choose Administration ® CCMS ® Control/Monitoring ®Performance Menu ® Database ® Activity.
Alternatively, you can use transaction st04n.
2. The monitor displays the overview on start-up or when you choose Detailed Analyses ® Main Monitor.
The following steps are generally valid for all screens, including screens in the submonitors.
3. If your SAP system uses Oracle RAC, in DB Instances you double-click the required RAC instance or Total for all RAC instances.
4. 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.
5. To refresh the display, choose Refresh.