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 |