{"id":65,"date":"2018-04-11T18:50:08","date_gmt":"2018-04-11T21:50:08","guid":{"rendered":"http:\/\/wordpress.rodrigosilvaesilva.com.br\/?p=65"},"modified":"2018-04-11T18:50:08","modified_gmt":"2018-04-11T21:50:08","slug":"listar-10-maiores-tabelas-do-banco","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/11\/listar-10-maiores-tabelas-do-banco\/","title":{"rendered":"Listar 10 maiores tabelas Oracle"},"content":{"rendered":"<h6>Select para listar as 10 maiores tabela do banco.<\/h6>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt;\ncolumn OWNER format a30\ncolumn SEGMENT_NAME format a30\nselect * from\n  (select owner, segment_name, trunc(sum(bytes)\/1024\/1024\/1024,2) \"SIZE GB\"\n      from dba_segments\n      where segment_type = 'TABLE'\n      group by segment_name, owner\n      order by 3 desc)\n      where rownum &lt;= 10;\n\nOWNER                          SEGMENT_NAME                      SIZE GB\n------------------------------ ------------------------------ ----------\nORCL                           NFSE_MENSAGENS                       7.02\nORCL                           AUD$                                 5.53\nORCL                           ORCL_LOG                              1.93\nORCL                           VENDAS                               1.56\nORCL                           VERSAO_LOG_DETALHES                  1.18\nORCL                           VENDA_ITENS                            .7\nORCL                           COMPRAS_ITENS                         .59\nORCL                           LANCAMENTO_CONTABIL                   .54\nORCL                           ORCL_MOVIMENTO                        .36\nORCL                           C100                                  .29\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select para listar as 10 maiores tabela do banco. SYS@ORCL &gt; column OWNER format a30 column SEGMENT_NAME format a30 select * from (select owner, segment_name, trunc(sum(bytes)\/1024\/1024\/1024,2) &#8220;SIZE GB&#8221; from dba_segments where segment_type = &#8216;TABLE&#8217; group by segment_name, owner order by 3 desc) where rownum &lt;= 10; OWNER SEGMENT_NAME SIZE GB &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;- ORCL NFSE_MENSAGENS&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[179,191],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-listar-10-maiores-tabelas-do-banco","tag-maiores-tabelas-oracle"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=65"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/65\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}