GVD_LOCK - Copy of GV$LOCK
Copy of GV$LOCK information is stored in SAP table GVD_LOCK.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_LOCK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| ADDR | Oracle monitoring: ADDR | X | ORA_ADDR | RAW | 8 | |
| KADDR | Oracle monitoring: KADDR | X | ORA_KADDR | RAW | 8 | |
| SID | Oracle monitoring: SID (Session) | ORA_SID | DEC | 12 | ||
| TYPE | Oracle Monitoring: Type of user or system lock | ORA_TYPE | CHAR | 2 | ||
| ID1 | Oracle monitoring: Lock identifier #1 (depends on type) | ORA_ID1 | DEC | 12 | ||
| ID2 | Oracle monitoring: Lock identifier #2 (depends on type) | ORA_ID2 | DEC | 12 | ||
| LMODE | Oracle monitoring: LMODE Lock mode in which the session hold | ORA_LMODE | DEC | 3 | ||
| REQUEST | Oracle monitoring: Lock mode in which the process requests | ORA_REQUEST | DEC | 12 | ||
| CTIME | Oracle monitoring: Time since current mode was granted | ORA_CTIME | DEC | 12 | ||
| BLOCK | Oracle monitoring: The lock is blocking another lock | ORA_BLOCK | DEC | 12 |