select tablespace_name, Sum(bytes)/1024/1024 from dba_segments group by tablespace_name order by sum(bytes) desc;
Y luego por ejemplo ver lo que ocupa cada tabla del tablespace:
select table_name, blocks from dba_tables where tablespace_name ='zzzzzz' order by blocks desc;
Saludos,
No hay comentarios:
Publicar un comentario