The HDB_DBCC_SQLPL event is used in SAP to view the SQL Plan cache. The SQL plan cache is where the plan cache entries are stored for later use. Each time a query is executed, the SQL plan cache is checked to see if there is a cached plan for the incoming query. If there is, this plan is automatically used.
Potential Use Cases
This event could be used in the following scenarios:
Compare the SQL queries executed to the SQL plan.
Visualize the number of SQL queries planned to be executed over time and identify anticipated load on the database based on the planned queries.
The event will look like this in Splunk:
Execute the dbacockpit transaction in the system. Open the Performance folder and double-click on “SQL Plan Cache”. Enter the desired user selection criteria in the top of the screen, and then click on the Execute button. The information displayed on the right side of the screen will match the data that is extracted and sent to Splunk.