SAP Table DB6PMHSD

DB6: Database Performance Statistics History

The table DB6PMHSD (DB6: Database Performance Statistics History) is a standard table in SAP ERP. It belongs to the package STU6.

Technical Information

Table	DB6PMHSD
Short Text	DB6: Database Performance Statistics History
Package	STU6
Table Type	Transparent Table

Fields for Table DB6PMHSD

Field Name	Key	Description	Data Element	Type	Length	Check Table
SYSID	✔	Name of SAP System	SYSYSID	CHAR	8
COMPTIME	✔	DB6: Timestamp (Format: YYYYMMDDHHMMSS)	DB6TSTAMP	CHAR	14
PARTITN	✔	DB6: partition number		INT4	10
PL_D_LRS		DB6: data logical reads		DEC	22
PL_D_PRS		DB6: data physical reads		DEC	22
PL_D_WS		DB6: data physical writes		DEC	22
PL_I_LRS		DB6: index logical reads		DEC	22
PL_I_PRS		DB6: index physical reads		DEC	22
PL_I_WS		DB6: index physical writes		DEC	22
CMMT_SQLST		DB6: commit statements		DEC	22
RBCK_SQLST		DB6: rollback statements		DEC	22
LCK_WAITS		DB6: lockwaits since 1st db connection		DEC	22
LCK_W_TM		DB6: total time db waited on locks in milliseconds		DEC	22
DEADLOCKS		DB6: deadlocks since 1st db connection		DEC	22
LCK_ESCALS		DB6: lock escalations since 1st db connection		DEC	22
XLK_ESCALS		DB6: X lock escalations since 1st db connection		DEC	22
BP_AV_RTM		DB6: Average Physical Read Time (ms)		DEC	22
BP_AV_WTM		DB6: Average Physical Write Time (ms)		DEC	22