Ansicht
Dokumentation

RSORA00E - DB-ORA-Monitor: New Entry Design

BAL_S_LOG - Application Log: Log header data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Purpose

Entry view of oracle database monitor.

Integration

Prerequisites

Features

The main screen is divided into 2 parts:
On the left side you can see 2 or 3 (in RAC systems) trees which enable you to navigate and select data. On the right side you see the content area which provides you with key figures and monitoring information.

The trees:

• Instances tree
  This tree is only displayed if your database is configured as a RAC system. It displays all SIDs and instances of your oracle database. You can:

• ... double click on an instance to view instance related key figures within the main monitor and all detailed analyses. Double click on an instance to view instance related key figures.

• ... double clock on the #Total# node to view averages / sums of key figures related to all instances

• History tree
  This tree gives you the possibility to select historic information (snapshot data). In the current version you are able to specifiy a #since# and an #up to# value. By double clicking on one of this 2 nodes you get a popup where you can select a snapshot. Dependent on the current submonitor you have the following alternatives:

• #Since# = DB start; #Up to# = Now
  This selection displays the current database state

• #Since# = a selected snapshot; #Up to# = now
  This selection displays the changes of key figures since this snapshot. The snapshot can be regarded as a #Reset#

• #Since# = DB start; #Up to# = a selected snapshot
  This selection displays the database state at the snapshot#s time.

• #Since# = a selected snapshot; #Up to# = another selected snapshot
  This selection displays the changes of key figures between these 2 snapshots. You can use this selection e.g. to display difference information of key figures which are a kind of counter.

• Detailed analyses tree
  This tree provides you with all available submonitors. By double clicking a submonitor you start this analysis with the current selections (instances tree, history tree). Depending on the detail analysis you can change the selections.

Content area

In the content area the main or submonitor information is displayed.

Additional navigation in the main monitor

• Detail / F2
  By double clicking on a key figure you get the key figure#s value related to all database instances and a total value (average or sum over all instances). This function is only useful for RAC systems.

• Refresh / F8
  This function reads the new current state from the database.

• Download / Ctrl+Shift+F9
  This function downloads the main monitor data (key figure values). You have different options to choos a file type.

• Snapshot / Shift+F6
  This function gives you the possibility to take a manual snapshot.

• Environment -> PerfMon.Collector -> Display log
  This function displays an overview of all periodic collector run protocols. The creation of periodic snapshots is executed within a periodic collector run.

• Environment -> PerfMon.Collector -> Display log
  This function navigates to the maintenance of table TCOLL. This table contains the entries of all reports which are responsible for collection of performance data. The entry for report RSORAHCL can be maintained for collecting periodic oracle snapshots. (See also online documentation of report RSORAHCL)

Selection

Standard Variants

Output

Activities

Example

ABAP Short Reference   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 4356 Date: 20240601 Time: 134316     sap01-206 ( 71 ms )