{"id":384,"date":"2008-10-19T17:22:38","date_gmt":"2008-10-19T15:22:38","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=384"},"modified":"2008-10-19T17:23:00","modified_gmt":"2008-10-19T15:23:00","slug":"renaming-sql-profiles-generated-with-oem","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2008\/10\/19\/renaming-sql-profiles-generated-with-oem\/","title":{"rendered":"Renaming SQL Profiles generated with OEM"},"content":{"rendered":"<p>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 <code>\"SYS_SQLPROF_0145a2a3145a2a31\"<\/code>. You can rename this name to a more descriptive name with <code>DBMS_SQLTUNE.ALTER_SQL_PROFILE.<\/code><\/p>\n<blockquote><p>BEGIN dbms_sqltune.alter_sql_profile ( NAME => &#8216;SYS_SQLPROF_0145a2a3145a2a31&#8217;, attribute_name => &#8216;NAME&#8217;, VALUE => &#8216;ORDER_QUERY_AVOID_ISS&#8217; );<br \/>\nEND;<br \/>\n\/ <\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;SYS_SQLPROF_0145a2a3145a2a31&#8221;. You can rename this name to a more descriptive name with DBMS_SQLTUNE.ALTER_SQL_PROFILE. BEGIN dbms_sqltune.alter_sql_profile ( NAME => &#8216;SYS_SQLPROF_0145a2a3145a2a31&#8217;, attribute_name => &#8216;NAME&#8217;, VALUE => &#8216;ORDER_QUERY_AVOID_ISS&#8217; ); END; \/<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,5],"tags":[],"class_list":["post-384","post","type-post","status-publish","format-standard","hentry","category-10g","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=384"}],"version-history":[{"count":2,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/384\/revisions"}],"predecessor-version":[{"id":386,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/384\/revisions\/386"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}