Show TOC

Database TablesLocate this document in the navigation structure

Use

You use DB Tables display mode to identify time-consuming database statements. The hit list shows tables accessed during the trace run. You also use it to identify accesses to buffered tables.

Features

The following information is displayed for each table entry:

  • Table Name

  • Access Mode

  • Accesses

    The number of accesses to the table. The system counts the OPEN and CLOSE-CURSOR operations that are implicitly part of SELECT statements.

  • Gross time

  • Internal Net Time

    The column Net (int) contains the time spent in the SAP table buffers or the database interface.

  • External Net Time

    The column Net (ext) contains the time spent on the database sever.

    Note

    If the external net times are high, the user should run the Performance Analysis (transaction code ST05) to examine the database statements more thoroughly.

  • Buffering

    This column can contain the following values that correspond to the technical settings of the table in the Data Dictionary:

    • Empty

      The table is not buffered

    • On

      The table is buffered.

    • Off

      Table buffering is allowed but is switched off.

    • Cust

      The table is not buffered but could be buffered because it is defined as a table that can be defined by the user.

      Note

      Tables with high external net times and Buffering equal to Cust. or Off should be allowed for buffering.

  • Buffering Types

    The column can contain the following values:

    • Single Record

    • Generic

    • Complete

  • Table Type

  • Pool/cluster Name

  • Description

  • Package

Functions

  • Display DDIC

    If you choose ( Display DDIC), the system jumps to the DDIC for the selected table.

  • Absolute and Percentage Times

    If you choose ( Absolute/Percentage Times), the system toggles between displaying the times as an absolute value or as a percentage of the total time.

  • Change Summarization

    If you choose ( Change Summarization), a dropdown box appears in which you can choose between the following summarization levels of the DB list:

    • Aggregation: Tables

      For every table there is a single entry in the list.

    • Aggregation: Statements

      For different DB statements, such as SELECT, SELECT SINGLE, INSERT, UPDATE, MODIFY, DELETE, there is a single entry per table.

    • Aggregation: DB Operations

      The SELECT statements are divided into OPEN CURSOR, FETCH, and CLOSE CURSOR.

  • Position

    If you choose ( Position Cursor), a dropdown box appears from which you can navigate to one of the following tools:

    • Position in the Times Tool

    • Position in the Hierarchy Tool

    • Position in the Hit List Tool

    • Position in the Processing Blocks Tool

    The system opens the selected entry in the relevant tool.