Data Description

The ORA_DB02_ENQU event is used in SAP to monitor enqueues and to reduce wait events.

Potential Use Cases

This event could be used in the following scenarios:

  • Alert on enqueue failures.

  • Alert on wait events.

  • View trends over time in a dashboard.

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

CUM_WAIT_TIME

Cumulated wait time

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EQ_NAME

Enqueue Name

String

EQ_TYPE

Enqueue Type

String

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_ENQU

String

FAILS

Number of failed requests

Number

GRANTS

Number of successful requests

Number

INST_ID

Instance ID

Number

PCT_FAILS

%of fails / total fails

Number (Percent)

PCT_GRANTS

% of successes / total successes

Number (Percent)

PCT_REQ

% of Enqueue requests of this type / total requests

Number (Percent)

PCT_WAIT

% of waits / total waits

Number (Percent)

PCT_WAIT_TIME

% wait time / total wait time

Number (Percent)

REQ_REASON

Enqueue Request Reason

String

TOTAL_REQ

Number of Requests

Number

TOTAL_WAIT

Number of Waits

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_ON_UPTIME

% wait time / uptime of the database

Number (Percent)