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.