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) |