{"id":40,"date":"2022-09-14T16:03:46","date_gmt":"2022-09-14T19:03:46","guid":{"rendered":"https:\/\/kappasoft.com.br\/wiki\/?p=40"},"modified":"2022-09-22T12:02:18","modified_gmt":"2022-09-22T15:02:18","slug":"como-verificar-recomendacoes-de-queries-no-oracle-via-comandos-sql","status":"publish","type":"post","link":"https:\/\/kappasoft.com.br\/wiki\/2022\/09\/14\/como-verificar-recomendacoes-de-queries-no-oracle-via-comandos-sql\/","title":{"rendered":"Como verificar recomenda\u00e7\u00f5es de queries no ORACLE via comandos SQL"},"content":{"rendered":"\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">-- drop da tuning task caso j\u00e1 tenha sido executada com esse nome alguma vez.\nEXEC DBMS_SQLTUNE.drop_tuning_task (task_name =&gt; 'SQL_TUNNING_TASK_SQL_ID');\n\n--Cria a tunning task da query a ser verificada\ndeclare\n\ttask_nm varchar2(100);\nbegin\n\ttask_nm := dbms_sqltune.create_tuning_task(SQL_ID='5m086tvnwp1p0',TASK_NAME='SQL_TUNNING_TASK_SQL_ID');\nend;\n\/\n\nALTER SESSION SET EVENTS '10046 trace name context forever, level 8';\n\n--Executa a an\u00e1lise da query criada acima\nEXEC dbms_sqltune.execute_tuning_task(TASK_NAME =&amp;gt; 'SQL_TUNNING_TASK_SQL_ID');\n\n--Verifica o status da execu\u00e7\u00e3o da task executada acima\nSELECT task_name, status FROM dba_advisor_log WHERE task_name = 'SQL_TUNNING_TASK_SQL_ID';\n\nSQL_TUNNING_TASK_SQL_ID COMPLETED\n\n--Select de verifica\u00e7\u00e3o das recomenda\u00e7\u00f5es\nSELECT DBMS_SQLTUNE.report_tuning_task('SQL_TUNNING_TASK_SQL_ID') AS recommendations FROM dual;<\/pre><\/div>\n\n\n\n<p><\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2],"tags":[],"class_list":["post-40","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-oracle"],"_links":{"self":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/40","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":4,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":54,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/posts\/40\/revisions\/54"}],"wp:attachment":[{"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kappasoft.com.br\/wiki\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}