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 |