Table/Structure Field list used by SAP ABAP Function Module GET_SQLPERFLOCKS_MSS (retrieve data from the counter objects: LOCKS)
SAP ABAP Function Module
GET_SQLPERFLOCKS_MSS (retrieve data from the counter objects: LOCKS) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DBCON - CON_NAME | Logical name for a database connection | ||
| 2 | DBCON - CON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) TYPE DBCON-CON_NAME DEFAULT 'DEFAULT' |
|
| 3 | MSSCOLLODESC - CNTR_NAME | MSSCOLLODESC-CNTR_NAME | ||
| 4 | MSSCOLLODESC - INST_NAME | MSSCOLLODESC-INST_NAME | ||
| 5 | MSSCOLLODESC - OBJ_NAME | MSSCOLLODESC-OBJ_NAME | ||
| 6 | MSSCOLLRESI - OBJ_NAME | MSSCOLLRESI-OBJ_NAME | ||
| 7 | MSSCOLLRESI - INST_NAME | MSSCOLLRESI-INST_NAME | ||
| 8 | MSSCOLLRESI - CNTR_VALUE | MSSCOLLRESI-CNTR_VALUE | ||
| 9 | MSSCOLLRESI - CNTR_NAME | MSSCOLLRESI-CNTR_NAME | ||
| 10 | MSS_PLOCKS - AVGWAITTIM | Number of SQL batch requests received by server. | ||
| 11 | MSS_PLOCKS - LCKREQUEST | Number of new lock requests or lock conversion requests. | ||
| 12 | MSS_PLOCKS - LCKTIMEOUT | Number of lock requests that have timed out | ||
| 13 | MSS_PLOCKS - LCKWAITTIM | Total wait time in seconds for locks (up to last second). | ||
| 14 | MSS_PLOCKS - LOCKTYPE | The type of lock object being monitored | ||
| 15 | MSS_PLOCKS - LOCKTYPE | The type of lock object being monitored | SOURCE VALUE(LOCKTYPE) LIKE MSS_PLOCKS-LOCKTYPE OPTIONAL |
|
| 16 | MSS_PLOCKS - NUMDEADLCK | Number of lock requests that resulted in a deadlock. | ||
| 17 | MSS_PLOCKS - NUMLOCKWTS | Number of lock requests that resulted in a wait |