Document toolboxDocument toolbox

ORA_DB02_TBLA

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

Data Description

The ORA_DB02_TBLA event is used in SAP to view the shared cursor cache from the viewpoint of the tables accessed. This helps you to identify performance problems for a table rather than for a statement, such as a missing index on a table.

Potential Use Cases

This event could be used in the following scenarios:

  • Identify opportunities where an index should be introduced for performance reasons.

  • Trend table use over time in a dashboard.

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 SQL Statement Analysis menu option. Double-click the Table Access option. The data displayed will match the data that is extracted and sent to Splunk.