Document toolboxDocument toolbox

ORA_DB02_CACH

Owned by Stephen Bangs
Last updated: Jun 30, 2022
1 min read

Data Description

The ORA_DB02_CACH event is used in SAP to check the shared cursor cache and related resource information. In addition, you can see an execution plan and the SQL statement. If the SQL statement is part of an ABAP program you can display the ABAP Source.

Potential Use Cases

This event could be used in the following scenarios:

  • Identify poorly performing SQL statements in the environment.

  • Correlate SQL statements to other system activity such as changes implemented.

  • Dashboard poorly performing SQL statements in the environment.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Log into the managed system and execute the dbacockpit transaction. Then expand the Performance menu on the left side of the screen, and then expand the SQL Statement Analysis menu. Then double-click the Shared Cursor Cache option. The information displayed on the screen will match the data that is extracted and sent to Splunk.