SQL History

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:

  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, provide the desired field values, and click the Search button.
  4. You can view more details about the executions by selecting the More Columns dropdown 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