Use this query to display the most important parameters for the use of a database on a daily basis.
Note
This query is not used in any of the delivered Web templates of interactive reporting. It is therefore intended primarily for users with extensive BI knowledge who require templates and usage examples for their own queries in the area of aggregates of ABAP statistical data.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
| Calendar Day |
0CALDAY |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
| Date |
'E2E: Reference to Calendar Day [0SMD_V_0CALDAY]' |
|
| Number of Read Accesses (x1000) |
'Direct Read Accesses [0CCMARDCN]' + 'Sequential Read Accesses [0CCMARSCN]' |
|
| Number of Change Accesses (x1000) |
0CCMACHCN |
— |
| Records Read (x1000) |
'Records Read, Direct [0CCMARDRC]' + 'Records Read, Sequential [0CCMARSRC]' |
|
| Number of Changed Records (x1000) |
0CCMACHRC |
— |
| Read Time [s] |
( 'Time for Logical Sequential Reading [0CCMARSTI]' + 'Time for Direct Sequential Reading [0CCMARDTI]' ) / 1000000 |
|
| Change Time [s] |
'Change Time [0CCMACHTI]' / 1000000 |