Show TOC

Database ActivitiesLocate this document in the navigation structure

Use

The Statistics user menu of the Database Assistant shows you a display of the database activities of the last four weeks.

Prerequisites

Prerequisites

You can only use the display for the basis database of the SAP system. These values are gathered from the last time database monitoring was started.

Procedure

In the Database Assistant, choose Start of the navigation path Statistics Next navigation step DB Activities End of the navigation path.

or

Open the DBA Cockpit (transaction code DBACOCKPIT) and choose Start of the navigation path Performance Next navigation step Activities History End of the navigation path (not for SAP NetWeaver 7.1).

Result

You receive information about database activities for the previous four weeks. You can set this output time frame. A collector logs the database activities of the database once a day, so that you can monitor activities over a specified period.

You can choose from the following views:

  • SQL Commands: Total number of SQL statements, commits, rollbacks, prepares

  • Cache Activities: Cache hit rates, number of reads and writes to the database

  • Other Activities: Number of table scans, log activities, lock information

Delete Statistics Data

Deleting statistics data can be done manually by specifying a time period/date or automatically by specifying a time period (in weeks).

More Information

DBA Cockpit:SAP MaxDB, Activities History

Activities Overview