SQL History Data

To view SQL history:

1. Open the Performance Hub page from the database details page, if not already open.

   Note:

   For more information about how to navigate to the Performance Hub page, see:

   • For Autonomous AI Database

   • For Base Database Service and Exadata Databases

   • For External Database Service

2. Click SQL History to display the SQL history tab. The top 500 executions by completion time are displayed.

3. You can search the records by using the Search By filter. To search, select the field by which you want to search, specify the values, and click the Search button.

4. You can view more details about the executions by selecting the More Columns drop-down on the right side of the executions table.

5. To view session details of a session, click the Session ID field in the executions table.

6. To view SQL history details of a SQL execution, click the SQL ID field in the executions table.

The following details are displayed in the executions table:

• Status

• Session ID

• Completion Time

• Duration

• SQL ID

• SQL Plan Hash

• User Name

• Service

• Module

• Action

• Parallel

• Database Time

• SQL Text

• Buffer Gets

• I/O Requests

• I/O Bytes