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):
|
|
STATUS |
VARCHAR2(8) |
Status of the SQL profile:
|
|
FORCE_MATCHING |
VARCHAR2(3) |
If YES, this causes SQL Profiles to target all SQL statements which have the same text after normalizing all literal values to bind variables. If a combination of literal values and bind variables is used in the same SQL text, then no transformation occurs. This is analogous to the matching algorithm use by the FORCE option of the CURSOR_SHARING parameter.
If |
|
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 |