Documentation forDatabase Performance Analyzer

Enable or disable the DPA Find SQL feature

When the Find SQL feature is enabled for a monitored database instance, you can search for any SQL statement that ran on the instance based on what you know about the SQL statement.

The Find SQL feature is available in DPA 2021.1 and later.

Enable the Find SQL feature

When you open the Find SQL page, it displays a message if it is not enabled for the selected database instance. You can enable the feature from the Find SQL page or by setting an advanced option. The feature can be enabled globally or for specific database instances.

If the Find SQL feature is enabled, DPA requires additional storage space for the indexes. By default, DPA stores the indexes on the DPA server, but you can move them.

From the Find SQL page

To enable the Find SQL feature from the Find SQL page:

  1. Below the message that Find SQL is not enabled, click Enable Find SQL feature.

    The Enable Find SQL feature dialog box opens.

  2. Choose one of the following options:

    • To enable the Find SQL feature only for the currently selected database instance, click Enable for this database instance.

    • To enable the Find SQL feature for all monitored database instances that do not currently have it enabled:

      1. Select the Enable for x registered database instances checkbox. The text on the button changes.

      2. Click the Enable for x database instances button.

From advanced options

To enable the Find SQL feature using advanced options, set the advanced option FIND_SQL_ENABLED to True:

  • Change the setting on the System Options tab to enable the feature globally.
  • Change it on the DB Instance Options tab to enable the feature for a specific database instance.

If you change the setting for a specific database instance, the global value is overridden for that instance.

Disable the Find SQL feature

When you disable the Find SQL feature, all associated indexes are removed. To disable the Find SQL feature, set the advanced option FIND_SQL_ENABLED to False:

  • Change the setting on the System Options tab to disable the feature globally.
  • Change it on the DB Instance Options tab to disable the feature for a specific database instance.