Data Description

The ORA_DB02_BFFR event is used in SAP to check buffer busy waits in the Oracle database.

A buffer busy wait indicates that there are some buffers in the buffer cache that multiple processes are attempting to access concurrently. This event happens because one of the following is true:

  • An Oracle block is being read into the buffer cache by another session and the session is waiting for that read to complete.

  • The buffer is already in the buffer cache but in an incompatible mode (that is, some other session is changing the buffer).

Potential Use Cases

This event could be used in the following scenarios:

  • Create alerts based on the percent utilization.

  • Trend buffer utilization over time.

  • Identify slowdowns in the buffer cache.

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, then expand the Wait Event Analysis menu option. Double-click on the Buffer Busy Wait option displayed. The information displayed on the screen will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

AVG_TIME

Average Time Waited (ms)

Number

CLASS

Block Class

String

COUNT_WAIT

Oracle monitoring: COUNT

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_BFFR

String

INST_ID

Instance

Number

PCTC

Percent of Buffer Busy Waits

Number (Percent)

PCTC_INST

Percent of Buffer Busy Waits per Instance

Number (Percent)

PCTT

Percent of Time of Buffer Waits

Number (Percent)

PCTT_INST

Percent of Time of Buffer Waits per Instance

Number (Percent)

TIME_WAIT

Oracle monitoring: field Time

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.

+ | -