Data Description

The ORA_DB02_FILE event is used in SAP to check filesystem requests in the Oracle database

Potential Use Cases

This event could be used in the following scenarios:

  • Trend file use over time in a dashboard

  • Alert if there are slowdowns in file read times.

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

Field Mapping

Field

Description

Unit of Measure

AVGBBWTIME

Oracle Monitoring: Average Buffer Busy Wait Time

Number

AVG_READ

Oracle Monitoring: Average Read

Number

BBW

Oracle Monitoring:Buffer Busy Waits

Number

BBWPERFILE

Oracle Monitoring: gv$filestat bbw per file(%)

Number (Percent)

BLKPERREAD

Oracle Monitoring: Block per Read

Number

BLK_READS

Oracle Monitoring: Block Reads

Number

BLK_WRITES

Oracle Monitoring: Block Writes

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_FILE

String

FILE_ID

Oracle monitoring: File of the file containing the extend

Number

FILE_NAME

File name

String

FULL_NAME

File name

String

INST_ID

Oracle monitor: Instance ID

Number

PCT2BLKRDS

Oracle Monitoring: V$Filestat Percentage of Block Reads

Number (Percent)

PCTBLKRDS

Oracle Monitoring: V$Filestat Percentage of Block Reads

Number (Percent)

PFAD_NAME

Name of path related to file name

String

READS

Oracle Monitoring: Reads

Number

SGLAVG

Oracle Monitoring: Single Average

Number

SGLBLKRDS

Oracle Monitoring: Single Block Reads

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.

+ | -

WRITES

Oracle Monitoring: Writes

Number

WRTAVGTIME

Oracle Monitoring: Write Average Time

Number