ORA_DB02_LTCH
Data Description
The ORA_DB02_LTCH event is used in SAP to view Oracle latch activity. A latch is a low-level serialization mechanism to protect shared data structures by preventing concurrent access to shared data structures in the Shared Global Area (SGA). Processes often have to wait to obtain a latch in order to access the data, which wastes CPU cycles.
Potential Use Cases
This event could be used in the following scenarios:
Alert on a high ratio of misses/gets for latch waits.
Trend latch wait percentages overtime.
Correlate latch waits with other events in the SAP ecosystem.
Splunk Event
The event will look like this in Splunk:
SAP Navigation
Log into the managed system and execute the dbacockpit transaction code. Then expand the Performance menu option on the left side of the screen, and then expand the Wait Event Analysis menu option. Double-click the Enqueue Stat option. The data displayed will match the data that is extracted and sent to Splunk.
Field Mapping
Field | Description | Unit of Measure |
|---|---|---|
CURRENT_TIMESTAMP | The date time stamp when the information was collected | YYYYMMDDHHMMSS |
EVENT_SUBTYPE | String | |
EVENT_TYPE | ORA_DB02_LTCH | String |
GETS | Oracle monitoring: Latch Gets | Number |
IMMEDIATE_GETS | Oracle monitoring: Latch Immediate Gets | Number |
IMMEDIATE_MISSES | Oracle monitoring: Latch Immediate Misses | Number |
INST_ID | Oracle monitor: Instance ID | Number |
MISSES | Oracle monitoring: Latch Misses | Number |
NAME | Oracle monitoring: Name | String |
PCT_SLEEPS | Oracle Monitoring: GV$LATCH % of sleeps | Number (Percent) |
PCT_WAIT_TIME | Oracle Monitoring: GV$LATCH % wait time | Number (Percent) |
R_MISSES_GETS | Oracle Monitoring: GV$LATCH ratio misses / gets | Number (Ratio) |
SLEEP1 | Oracle monitoring: Latch Sleep 1 | Number |
SLEEP2 | Oracle monitoring: Latch Sleep 2 | Number |
SLEEP3 | Oracle monitoring: Latch Sleep 3 | Number |
SLEEP4 | Oracle monitoring: Latch Sleep 4 | Number |
SLEEPS | Oracle monitoring: Latch Sleeps | Number |
SPIN_GETS | Oracle monitoring: Latch Spin Gets | Number |
UTCDIFF | The UTC OFFSSET in HHMMSS that the data was collected in | HHMMSS |
UTCSIGN | The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in. | + | - |
WAIT_TIME | Oracle monitoring: Latch Wait Time | Number |