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 | Table/Structure Field | DBCON - CON_NAME | Logical name for a database connection | |
2 | Table/Structure Field | DBCON - CON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) TYPE DBCON-CON_NAME DEFAULT 'DEFAULT' |
3 | Table/Structure Field | MSSCOLLODESC - CNTR_NAME | MSSCOLLODESC-CNTR_NAME | |
4 | Table/Structure Field | MSSCOLLODESC - INST_NAME | MSSCOLLODESC-INST_NAME | |
5 | Table/Structure Field | MSSCOLLODESC - OBJ_NAME | MSSCOLLODESC-OBJ_NAME | |
6 | Table/Structure Field | MSSCOLLRESI - OBJ_NAME | MSSCOLLRESI-OBJ_NAME | |
7 | Table/Structure Field | MSSCOLLRESI - INST_NAME | MSSCOLLRESI-INST_NAME | |
8 | Table/Structure Field | MSSCOLLRESI - CNTR_VALUE | MSSCOLLRESI-CNTR_VALUE | |
9 | Table/Structure Field | MSSCOLLRESI - CNTR_NAME | MSSCOLLRESI-CNTR_NAME | |
10 | Table/Structure Field | MSS_PLOCKS - AVGWAITTIM | Number of SQL batch requests received by server. | |
11 | Table/Structure Field | MSS_PLOCKS - LCKREQUEST | Number of new lock requests or lock conversion requests. | |
12 | Table/Structure Field | MSS_PLOCKS - LCKTIMEOUT | Number of lock requests that have timed out | |
13 | Table/Structure Field | MSS_PLOCKS - LCKWAITTIM | Total wait time in seconds for locks (up to last second). | |
14 | Table/Structure Field | MSS_PLOCKS - LOCKTYPE | The type of lock object being monitored | |
15 | Table/Structure Field | MSS_PLOCKS - LOCKTYPE | The type of lock object being monitored | SOURCE VALUE(LOCKTYPE) LIKE MSS_PLOCKS-LOCKTYPE OPTIONAL |
16 | Table/Structure Field | MSS_PLOCKS - NUMDEADLCK | Number of lock requests that resulted in a deadlock. | |
17 | Table/Structure Field | MSS_PLOCKS - NUMLOCKWTS | Number of lock requests that resulted in a wait |