DB6PMHSD - DB6: Database Performance Statistics History
DB6: Database Performance Statistics History information is stored in SAP table DB6PMHSD.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".
Fields for table DB6PMHSD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
COMPTIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | X | DB6TSTAMP | CHAR | 14 | |
PARTITN | DB6: partition number | X | INT4 | 4 | ||
PL_D_LRS | DB6: data logical reads | DEC | 12 | |||
PL_D_PRS | DB6: data physical reads | DEC | 12 | |||
PL_D_WS | DB6: data physical writes | DEC | 12 | |||
PL_I_LRS | DB6: index logical reads | DEC | 12 | |||
PL_I_PRS | DB6: index physical reads | DEC | 12 | |||
PL_I_WS | DB6: index physical writes | DEC | 12 | |||
CMMT_SQLST | DB6: commit statements | DEC | 12 | |||
RBCK_SQLST | DB6: rollback statements | DEC | 12 | |||
LCK_WAITS | DB6: lockwaits since 1st db connection | DEC | 12 | |||
LCK_W_TM | DB6: total time db waited on locks in milliseconds | DEC | 12 | |||
DEADLOCKS | DB6: deadlocks since 1st db connection | DEC | 12 | |||
LCK_ESCALS | DB6: lock escalations since 1st db connection | DEC | 12 | |||
XLK_ESCALS | DB6: X lock escalations since 1st db connection | DEC | 12 | |||
BP_AV_RTM | DB6: Average Physical Read Time (ms) | DEC | 12 | |||
BP_AV_WTM | DB6: Average Physical Write Time (ms) | DEC | 12 |