{"id":346,"date":"2009-07-27T09:30:51","date_gmt":"2009-07-27T14:30:51","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=346"},"modified":"2011-07-06T10:15:46","modified_gmt":"2011-07-06T15:15:46","slug":"dbms_sqltune-using-awr-data","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2009\/07\/27\/dbms_sqltune-using-awr-data\/","title":{"rendered":"dbms_sqltune using AWR data"},"content":{"rendered":"<p>Today I wanted to use dbms_sqltune on a SQL statement that was run on Friday, but had not been executed since then.  dbms_sqltune by default will assume the statement is still in the shared pool.  If it is not, you must use one of the overloaded procedures for create_tuning_task.<\/p>\n<p>See below&#8230;<\/p>\n<pre lang=\"plsql\" line=\"1\">\r\nvariable l varchar2(4000)\r\nbegin\r\n  :l := dbms_sqltune.create_tuning_task(begin_snap => 47631, end_snap => 47637, \r\n                                        sql_id=>'gjnx2b8t0nz90',task_name=>'wcrs');\r\nend;\r\n\/\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Today I wanted to use dbms_sqltune on a SQL statement that was run on Friday, but had not been executed since then. dbms_sqltune by default will assume the statement is still in the shared pool. If it is not, you&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2009\/07\/27\/dbms_sqltune-using-awr-data\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/346"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=346"}],"version-history":[{"count":8,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/346\/revisions"}],"predecessor-version":[{"id":401,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/346\/revisions\/401"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}