GVD_LOCK_ACTIVTY - Copy of GV$LOCK_ACTIVITY
Copy of GV$LOCK_ACTIVITY information is stored in SAP table GVD_LOCK_ACTIVTY.
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_ACTIVTY
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 | |
| FROM_VAL | Oracle monitoring: PCM lock initial state: NULL; S; X; SSX | X | ORA_FROM_VAL | CHAR | 4 | |
| TO_VAL | Oracle monitoring: PCM lock initial state: NULL; S; X; SSX | X | ORA_TO_VAL | CHAR | 4 | |
| ACTION_VAL | Oracle monitoring: Description of lock conversions | ORA_ACTION_VAL | CHAR | 51 | ||
| COUNTER | Oracle monitoring: Nbr of times the lock operation executed | ORA_COUNTER | DEC | 6 |