DBA_SQL_PROFILES

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

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the SQL profile
`CATEGORY`	`VARCHAR2(128)`	`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`	`TIMESTAMP(6)`	`NOT NULL`	Timestamp when the SQL profile was created
`LAST_MODIFIED`	`TIMESTAMP(6)`		Timestamp when the SQL profile was last modified
`DESCRIPTION`	`VARCHAR2(500)`		Text description provided for the SQL profile
`TYPE`	`VARCHAR2(7)`		Type of the SQL profile (how it was created): `MANUAL` `AUTO`
`STATUS`	`VARCHAR2(8)`		Status of the SQL profile: `ENABLED` `DISABLED` `VOID`
`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 `NO`, 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
`TASK_EXEC_NAME`	`VARCHAR2(128)`		Advisor execution name for the SQL profile
`TASK_OBJ_ID`	`NUMBER`		Advisor object ID for the SQL profile
`TASK_FND_ID`	`NUMBER`		Advisor finding ID for the SQL profile
`TASK_REC_ID`	`NUMBER`		Advisor recommendation ID for the SQL profile
`TASK_CON_DBID`	`NUMBER`		Database ID for the PDB tuning task generating the SQL profile