Programme SAP RSSQD000 - SAP DB: Database Activity Overview (ST04)

Description
Online program.
This program generates an overview of the current database activities.Only the most important parameters are displayed. For more details,choose the appropriate submenu option. All values are calculated sincethe last database restart.

Precondition
Call transaction ST04.

Output

  • Cache activity:

  • Size, accesses and quality of the main buffers
    • SQL commands:

    • Number of SQL commands (Commits, Rollbacks, etc.)
      • I/O activity:

      • Number of physical and logical I/O operations
        • Locking activity:

        • Number and type of retained and requested locks
          • Logging activity:

          • Information about activities on log area of database
            • Table scans, sorts:

            • Number of searches over tables
              Number of sorts and sorted lines
              The button 'DB version' displays the current version of the databasesoftware in a pop-up window.
              Example