How to list SQL profiles in Oracle

SQL profiles carry statistical hints for the optimizer. Auditing them regularly catches profiles that were left behind after a plan change, or drift where a profile is no longer beneficial.

COLUMN category FORMAT a10
COLUMN sql_text FORMAT a20

SELECT created, name, type, sql_text, category, status
FROM   dba_sql_profiles;