Renaming SQL Profiles generated with OEM
By Martin | October 19th, 2008 | Category: 10g, Oracle Database | No Comments »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’ );
END;
/