{"id":1479,"date":"2017-11-28T10:56:13","date_gmt":"2017-11-28T13:56:13","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=1479"},"modified":"2018-02-01T16:48:14","modified_gmt":"2018-02-01T19:48:14","slug":"dropping-plans-e-baselines","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/dropping-plans-e-baselines\/","title":{"rendered":"Dropping Plans e Baselines"},"content":{"rendered":"<p>Para apagar um Baselines e bem simples , logue como sys e\u00a0 coloque o ID do seu\u00a0Baselines\u00a0 no bloco abaixo:<\/p>\n<pre class=\"lang:default decode:true \">SET SERVEROUTPUT ON\r\nDECLARE\r\nl_plans_dropped PLS_INTEGER;\r\nBEGIN\r\nl_plans_dropped := DBMS_SPM.drop_sql_plan_baseline (\r\nsql_handle =&gt; NULL,\r\nplan_name =&gt; 'SQL_PLAN_4s77gz996aammee82b912');\r\n\r\nDBMS_OUTPUT.put_line(l_plans_dropped);\r\nEND;\r\n\/<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 28 10:03:25 2017\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,\r\nOLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; SET SERVEROUTPUT ON\r\nDECLARE\r\nl_plans_dropped PLS_INTEGER;\r\nBEGIN\r\nl_plans_dropped := DBMS_SPM.drop_sql_plan_baseline (\r\nsql_handle =&gt; NULL,\r\nplan_name =&gt; 'SQL_PLAN_4s77gz996aammee82b912');\r\n\r\nDBMS_OUTPUT.put_line(l_plans_dropped);\r\nEND;\r\n\/SQL&gt; 2 3 4 5 6 7 8 9 10\r\n1\r\n\r\nPL\/SQL procedure successfully completed.<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para apagar um Baselines e bem simples , logue como sys e\u00a0 coloque o ID do seu\u00a0Baselines\u00a0 no bloco abaixo: SET SERVEROUTPUT ON DECLARE l_plans_dropped PLS_INTEGER; BEGIN l_plans_dropped := DBMS_SPM.drop_sql_plan_baseline ( sql_handle =&gt; NULL, plan_name =&gt; &#8216;SQL_PLAN_4s77gz996aammee82b912&#8217;); DBMS_OUTPUT.put_line(l_plans_dropped); END; \/ &nbsp; sqlplus \/ as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 28 10:03:25 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 &#8211; 64bit Production[&#8230;]<\/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,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1479"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=1479"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1479\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=1479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=1479"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=1479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}