Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_SQL_PROFILES

DBA_SQL_PROFILES displays information about SQL profiles currently created for specific SQL statements.

Column Datatype NULL Description
NAME VARCHAR2(30) NOT NULL Name of the SQL profile
CATEGORY VARCHAR2(30) NOT NULL Category of the SQL profile
SIGNATURE NUMBER NOT NULL Unique identifier generated from normalized SQL text
SQL_TEXT CLOB NOT NULL Un-normalized SQL text
CREATED DATE NOT NULL Timestamp when the SQL profile was created
LAST_MODIFIED DATE NOT NULL Timestamp when the SQL profile was last modified
DESCRIPTION VARCHAR2(500)   Text description provided for the SQL profile
TYPE VARCHAR2(9)   Type of the SQL profile (how it was created):
  • MANUAL

  • AUTO-TUNE

STATUS VARCHAR2(8)   Status of the SQL profile:
  • ENABLED

  • DISABLED

  • VOID

FORCE_MATCHING VARCHAR2(3)
If TRUE this causes SQL Profiles to target all SQL statements which have the same text after normalizing all literal values to bind variables. (Note that if a combination of literal values and bind variables is used in the same SQL text, no transformation occurs). This is analogous to the matching algorithm use by the FORCE option of the CURSOR_SHARING parameter.

If FALSE, literals are not transformed. This is analogous to the matching algorithm used by the EXACT option of the CURSOR_SHARING parameter.

TASK_ID NUMBER
Advisor task ID that generated the SQL profile
EXECUTION_NAME VARCHAR2(30)
Advisor execution name for the SQL profile
OBJECT_ID NUMBER
Advisor object ID for the SQL profile
FINDING_ID NUMBER
Advisor finding ID for the SQL profile
REC_ID NUMBER
Advisor recommendation ID for the SQL profile

See Also:

The DBMS_SQLTUNE package in Oracle Database PL/SQL Packages and Types Reference