Renaming SQL Profiles generated with OEM

If you created an SQL Profile in OEM by executing the SQL Tuning Advisor Job and implementing the profile, then the profile has a system-generated name like "SYS_SQLPROF_0145a2a3145a2a31". You can rename this name to a more descriptive name with DBMS_SQLTUNE.ALTER_SQL_PROFILE.

BEGIN dbms_sqltune.alter_sql_profile ( NAME => ‘SYS_SQLPROF_0145a2a3145a2a31’, attribute_name => ‘NAME’, VALUE => ‘ORDER_QUERY_AVOID_ISS’ );

Leave Comment