Show TOC

Historical Database Performance Statistics (Oracle)Locate this document in the navigation structure

 Historical Database Performance Statistics (Oracle)

Use

You can use this procedure to display historical database performance data.

Procedure
  1. Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Activity.

    Alternatively, call transaction ST04.

  2. Choose Detail analysis menu → Performance Database.

A detailed database history is displayed. There is a variety of display options available:

You can display:

  • activity peaks (Peaks)
  • display delta values (click on a day and then choose Intervals)
  • display peaks graphically (Graph by column)

When you choose a day, extracts of database activity are displayed at two-hour intervals. This is useful if you want to perform a trend analysis. The header line of this overview screen contains two additional dates. You can immediately select one of these days for further analysis.