Oracle Cloud Infrastructure Documentation

Manage SQL Profiles

You can view and manage SQL profiles for a Managed Database.

A SQL profile is a database object that contains auxiliary statistics specific to a SQL statement. SQL Tuning Advisor can recommend a SQL profile to correct suboptimal optimizer estimates and help the optimizer select better execution plans. You can perform tasks such as enabling, disabling, dropping, and changing the category of a SQL profile. For more information, see Managing SQL Profiles in Oracle Database SQL Tuning Guide.

Note

  • SQL profiles is currently available in preview mode for early exploration. For more information about feature availability and access, contact Oracle Support.
  • SQL profiles is currently only available for External Databases and Oracle Cloud Databases version 18c and later.

To view SQL profiles, go to the Managed database details page, expand Management in the left pane, and click SQL profiles. The SQL profiles section lists the SQL profiles and displays the following information. You can enable the Search filter to search for specific SQL profiles:

  • Name: Name of the SQL profile.
  • SQL text: SQL statement associated with the SQL profile. Click the SQL text to view the complete SQL statement.
  • Category: Category to which the SQL profile belongs.
  • Status: Status of the SQL profile, such as Enabled or Disabled.
  • Force matching: Indicates whether force matching is enabled for the SQL profile.
  • SQL Tuning Advisor ID: ID of the SQL Tuning Advisor task associated with the creation of the SQL profile.
  • Created: Date and time the SQL profile was created.
  • Last modified: Date and time the SQL profile was last modified.

Privileges Required to Manage SQL Profiles

You must have the following privileges to manage SQL profiles:

  • For read operations, such as viewing SQL profiles:

    READ ON SYS.DBA_SQL_PROFILES

  • For write operations, such as enabling, disabling, dropping, and changing the category of SQL profiles:

    ADMINISTER SQL MANAGEMENT OBJECT

Perform SQL Profile Management Tasks

You can click the Actions icon (Actions) for a SQL profile and perform the following tasks:

  • Enable/Disable: Enable or disable the SQL profile. The option displayed depends on the current status of the SQL profile.
  • Drop: Drop the SQL profile.
  • Change category: Change the category of the SQL profile. The category determines which sessions can use the SQL profile. In the Change category for SQL Profile panel, enter the new category and click Save.