{"id":45,"date":"2015-09-05T14:40:19","date_gmt":"2015-09-05T12:40:19","guid":{"rendered":"http:\/\/geekinto.com\/?p=45"},"modified":"2015-09-05T14:50:08","modified_gmt":"2015-09-05T12:50:08","slug":"how-to-use-the-sql-tuning-advisor-feature-in-oracle-sql-developer","status":"publish","type":"post","link":"https:\/\/howoracleapex.com\/?p=45","title":{"rendered":"How to use the SQL Tuning Advisor feature in Oracle SQL Developer"},"content":{"rendered":"<p>First execute some codes ..<\/p>\n<pre class=\"lang:mysql decode:true \">ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS='DIAGNOSTIC+TUNING';\r\nGRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &amp;USER;\r\nGRANT advisor to &amp;USER;\r\nGRANT administer sql tuning set to &amp;USER;\r\nEXEC DBMS_STATS.DELETE_SCHEMA_STATS ('&amp;USER');\r\n<\/pre>\n<p>And show this toturial to help you<br \/>\n<a href=\"http:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/obe\/db\/sqldev\/r32\/Tuning_Advisor_OBE\/SQL%20Tuning%20Advisor.html\" target=\"_blank\">link<\/a><\/p>\n<p>source:<\/p>\n<p><a href=\"http:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/obe\/db\/sqldev\/r32\/Tuning_Advisor_OBE\/SQL%20Tuning%20Advisor.html\" target=\"_blank\">http:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/obe\/db\/sqldev\/r32\/Tuning_Advisor_OBE\/SQL%20Tuning%20Advisor.html<\/a><\/p>\n<p><a href=\"http:\/\/www.dbzoo.com\/blog\/enabling_oracle_sql_advisor\" target=\"_blank\">http:\/\/www.dbzoo.com\/blog\/enabling_oracle_sql_advisor<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>First execute some codes .. ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS=&#8217;DIAGNOSTIC+TUNING&#8217;; GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &amp;USER; GRANT advisor to &amp;USER; GRANT administer sql tuning set to &amp;USER; EXEC DBMS_STATS.DELETE_SCHEMA_STATS (&#8216;&amp;USER&#8217;); And&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5,21],"tags":[],"class_list":["post-45","post","type-post","status-publish","format-standard","hentry","category-dba","category-sql","category-sql-developer"],"_links":{"self":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/45","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=45"}],"version-history":[{"count":4,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions"}],"predecessor-version":[{"id":49,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions\/49"}],"wp:attachment":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}