Volumetría tabla existente | ExpoDBA

Volumetría tabla existente

Volumetría tabla existente

col owner format a30 
col tabla format a30 
col mb format 999999.99 
col tablespace format a30 
set linesize 200 

select owner, segment_name tabla, sum(bytes)/1024/1024 mb, tablespace_name tablespace 
from dba_segments 
where segment_type = 'TABLE' --nombre_tabla vacío para traer todas las tablas 
and segment_name like '%&nombre_tabla%' 
group by owner, tablespace_name, segment_name 
order by 1,2,3,4;