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`

See Also:

The DBMS_SQLTUNE package in PL/SQL Packages and Types Reference