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