SQL History
The SQL History tab provides granular statistics on all the SQL executions in the database.
SQL History is only available for Oracle Database 23ai and above versions. Additionally, the
SQL_HISTORY_ENABLED database parameter must be set to
TRUE to view SQL History data.
The table in the SQL history tab displays the top 500 executions by completion time.
The search filter is available with options to filter based on status, session ID, duration, SQL type, parallel execution, SQL ID, user name, container name, service, module, action, and SQL text.
The table in the SQL history tab displays the following information about SQL executions: status, session ID, completion time, duration, SQL ID, SQL plan hash, user name, service, module, action, parallel execution, database time, and SQL text. You can also show or hide additional statistics columns using the More Columns dropdown: buffer gets, I/O requests, and I/O bytes.
For more information, see SQL History.