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.

Space requirements for the Find SQL indexes

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.

The amount of space required is determined by the number of monitored database instances with Find SQL enabled. Index files for one instance can take up to 300 MB. So, for example, if you are monitoring 120 instances, reserve at least 36 GB to provide adequate disk space for the Find SQL indexes:

120 x 0.3 GB = 36 GB

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.

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 the button Enable for this database instance.

    • To enable the Find SQL feature for all monitored database instances that do not currently have it enabled, select the check box Enable for x registered database instances.

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.