Analyzing Database Accesses

Prerequisites

You have traced your ABAP program either Tracing an ABAP Program or by Scheduling a Trace.

Context

Whenever the database portion of a runtime distribution is (unexpected) high, you may wish to find out, which database accesses in your application have caused this to happen.

The Database Accesses tool allows you to identify and analyze the top consumers during database accesses. It provides you with a list of all database tables and table views that are used when the ABAP program in question is run. In addition, detailed information for each database access, such as access type, buffer settings, or duration of table accesses is provided.

Procedure

Open the ABAP Traces view in the ABAP Profiling perspective.
In the view, expand the relevant project tree and double-click the trace entry. The Overview page appears for the selected trace.
Choose the Database Accesses tab.

Figure 1: The Database Accesses view provides you with details for each database access in your ABAP program

Results

Using the Databases Accesses Views, you can...

identify top consumers during the database accesses
check which portion of runtime is used by database accesses from ABAP kernel or system events
get a complete list of tables (views) that are used during the execution of you ABAP program
check, where your program repeats the same database access
analyze further details of each database access and check, for example, whether and how the tables are buffered
navigate to the table (view) definition in the ABAP Dictionary.

Tip

To restrict the data in the view, you can enter the appropriate filter text or configure the view by using the context menu in the table header.

Figure 2: Configuring the view details using the context menu in the table header