Show TOC

E2E Reporting: ABAP Database Performance Locate this document in the navigation structure

Query Query: 0E2EREP_ABAP_DB_PERFORMANCE

 

This query is used in interactive reporting in the Technical Monitoring work center. It displays the most important parameters about the usage and performance of a database. The query is displayed in the following interactive reports:

  •   ABAP System   Performance   DB Performance  

  •   Database   Performance   ABAP  

The query is used in the Web Template 0E2EREP_DBABAP_PERFORMANCE (Interactive Reports: ABAP DB Performance).

Note Note

For correct usage, this query must be used in the context of the Web template listed above. Using the query without this wrapper is not meaningful.

End of the note.

Structure

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Calendar Day

0CALDAY

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Read: Time per Access [ms]

( 'Time for Logical Direct Read [0CCMARDTI]' + 'Time for Logical Sequential Reading [0CCMARSTI]' ) / 1000 / ( 'Direct Read Accesses [0CCMARDCN]' + 'Sequential Read Accesses [0CCMARSCN]' )

Number of Read Accesses (x1000)

'Direct Read Accesses [0CCMARDCN]' + 'Sequential Read Accesses [0CCMARSCN]'

Change: Time per Access [ms]

'Change Time [0CCMACHTI]' / 1000 / 'Number of Logical Database Changes [0CCMACHCN]'

Number of Change Accesses (x1000)

0CCMACHCN

—