Add excluded SQL statements back to DPA trend charts and analysis

If you excluded SQL statements from DPA trend charts and analysis, you can add them back if needed.

Add excluded SQL statements back to trend charts

  1. On the DPA menu, click Options.

  2. Under Administration > Configuration, click Excluded SQL Statements.

    The Excluded SQL Statements dialog box lists the SQL statements that are excluded from trends charts.

  3. Locate the SQL statement in the list:
    • Use the drop-down menu at the top to sort by exclusion date, database instance name, or SQL ID (name or hash).

    • Enter a string in the Search bar to show only SQL statements whose ID, database instance, or database type includes the search string.

    • Hold the mouse pointer over the icon to display the SQL.

  4. Select the SQL statement.
  5. Click Re-include Selected.
  6. Click the x in the top-right corner to close the dialog box.

Add excluded SQL statements back to analysis

  1. If the SQL statement is currently excluded from trends charts, add it back to trends charts.
  2. In any chart legend, click the name or hash value that represents the SQL statement.

    The Query Details page displays information about the SQL statement.

  3. In the top-right corner, click SQL Properties.

    The SQL Properties dialog opens.

  4. Under Advanced Settings, select Enable advisor analysis.

  5. Click Save.