SQL Statement History

This screen presents historical SQL statement performance data. Use transaction DBACOCKPIT or ST04. Then choose Performance → History → SQL Statement History.

Features

The main screen is a split grid control where the top grid shows a list of data collection entries in reverse chronological order. By default, data is collected every twenty minutes using the DB Collector job. Six columns show data for the total amount of Calls, Physical reads, Logical reads, Logical writes, Elapsed time and CPU time measured during the period. Additional columns show other overall system data measured at the time. For example, the cache sizes and the page life expectancy are shown. You can sort the grid by any of the columns using the standard ALV grid features.

Alternatively, select a set of rows and then press Details for selected rows. All the statements collected for those periods are displayed in the bottom half of the split screen.

For each statement, you can display the full SQL statement by clicking on SQL Statement. To view the execution plan for the recorded statement, click on Recorded plan. To view the current plan for the same statement click on Current cached plan.

For each statement, you can display the full SQL statement by clicking on SQL Statement. To view the execution plan for the recorded statement, click on Explain. To view the current plan for the same statement click on Explain current plan from memory.

To extend the number of columns on the bottom grid, click on Detailed view. This shows all the performance data stored for that statement.