Select para listar as 10 maiores tabela do banco.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SYS@ORCL > column OWNER format a30 column SEGMENT_NAME format a30 select * from (select owner, segment_name, trunc(sum(bytes)/1024/1024/1024,2) "SIZE GB" from dba_segments where segment_type = 'TABLE' group by segment_name, owner order by 3 desc) where rownum <= 10; OWNER SEGMENT_NAME SIZE GB ------------------------------ ------------------------------ ---------- ORCL NFSE_MENSAGENS 7.02 ORCL AUD$ 5.53 ORCL ORCL_LOG 1.93 ORCL VENDAS 1.56 ORCL VERSAO_LOG_DETALHES 1.18 ORCL VENDA_ITENS .7 ORCL COMPRAS_ITENS .59 ORCL LANCAMENTO_CONTABIL .54 ORCL ORCL_MOVIMENTO .36 ORCL C100 .29 |