{"id":74,"date":"2015-03-30T10:53:00","date_gmt":"2015-03-30T13:53:00","guid":{"rendered":"http:\/\/maxoracle.com\/2015\/03\/30\/verificar-as-recomendacoes-do-segment-advisor-sem-entrar-no-em\/"},"modified":"2015-03-30T10:53:00","modified_gmt":"2015-03-30T13:53:00","slug":"verificar-as-recomendacoes-do-segment-advisor-sem-entrar-no-em","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=74","title":{"rendered":"Verificar as recomendacoes do SEGMENT ADVISOR sem entrar no EM"},"content":{"rendered":"<p>Com a consulta abaixo conseguimos ter acesso as recomendacoes do Segment advisor.<\/p>\n<p><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">SELECT&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;Segment Advice &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;&#8216;|| chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;TABLESPACE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || tablespace_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SEGMENT_OWNER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || segment_owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SEGMENT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || segment_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;ALLOCATED_SPACE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || allocated_space&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;RECLAIMABLE_SPACE: &#8216; || reclaimable_space || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;RECOMMENDATIONS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || recommendations&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SOLUTION 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SOLUTION 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || c2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SOLUTION 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || c3 Advice<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">FROM<\/span><br style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\" \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE(dbms_space.asa_recommendations(&#8216;FALSE&#8217;, &#8216;FALSE&#8217;, &#8216;FALSE&#8217;));&nbsp;<\/span><br \/><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\"><br \/><\/span><span style=\"background-color:white;color:#444444;font-family:Arial, Tahoma, Helvetica, FreeSans, sans-serif;font-size:13px;line-height:18.200000762939px;\"><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Com a consulta abaixo conseguimos ter acesso as recomendacoes do Segment advisor. SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;Segment Advice &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;&#8216;|| chr(10) ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;TABLESPACE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || tablespace_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SEGMENT_OWNER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || segment_owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || chr(10) ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8216;SEGMENT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &#8216; || segment_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || &hellip; <a href=\"https:\/\/www.soudba.com.br\/?p=74\">Continue lendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-sem-categoria"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/74\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}