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.
The event will look like this in Splunk:
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.