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.