Viewing Details of a SQL Profile
Submitted by dmann on Wed, 10/20/2010 - 11:10
The following query will show the details of the most recently created SQL Profiles first. Each component hint of the Profile is returned one per row.
SELECT CREATED, PROFILE_NAME, ATTR_VALUE, SQL_TEXT FROM DBA_SQL_PROFILES PROF, DBMSHSXP_SQL_PROFILE_ATTR ATTR WHERE PROF.NAME=ATTR.PROFILE_NAME ORDER BY CREATED DESC, NAME, ATTR_NUMBER;