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:

  • Start of the navigation path ABAP System Next navigation step Performance Next navigation step DB Performance End of the navigation path

  • Start of the navigation path Database Next navigation step Performance Next navigation step ABAP End of the navigation path

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

—