DBA_SQL_PROFILES displays information about SQL profiles currently created for specific SQL statements.
Name of the SQL profile
Category of the SQL profile
Unique identifier generated from normalized SQL text
Un-normalized SQL text
Timestamp when the SQL profile was created
Timestamp when the SQL profile was last modified
Text description provided for the SQL profile
Type of the SQL profile (how it was created):
Status of the SQL profile:
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.