Data Description

The ORA_DB02_SYEH event is used in SAP to provide an overview of the history of system events of the Oracle instance(s). It helps you to work out whether:

  • The load has changed during the last few days

  • The instances have load peaks

  • One instance has more load compared to the other instances, in a RAC environment

Potential Use Cases

This event could be used in the following scenarios:

  • Dashboard historical system load.

  • Identify anomalies in overall database load.

  • Correlate database load with changes in the application environment.

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 System Event History option. The data displayed will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

AVG_WAIT

Oracle monitor: AVERAGE_WAIT

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EVENT

Oracle monitor: EVENT

String

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_SESS

String

HIDED_DATE

SAP Date of the Oracle snapshot

YYYYMMDD

INST_ID

Oracle monitor: Instance ID

Number

SNAPSHOT_ID

Oracle monitor: snapshot ID

Number

SNAP_DATE

SAP Date of the Oracle snapshot

YYYYMMDD

SNAP_TIME

SAP Time of oracle snapshot

HHMMSS

TIME_FROM

SAP Time of oracle snapshot

HHMMSS

TIME_WAITED

Oracle monitor: TIME_WAITED

Number

TI_WAIT_MIC

Oracle monitor: TIME_WAITED_MICRO

Number

TT_TIMEOUTS

Oracle monitor: TOTAL_TIMEOUTS

Number

TT_WAITS

Oracle monitor: ORA_TOTAL_WAITS

Number

TT_WAITS_PERC

Data Element "Total Wait Time in Percent"

Number (Percent)

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.

+ | -

WEEKDAY

Data Element weekday for ORA_SYSTEM_EVENT_HISTORY

String