Dimensione di una tabella

Di seguito alcune query per individuare le dimensioni in MB di una tabella.

select

segment_name table_name,

sum(bytes)/(1024*1024) table_size_meg

from

user_extents

where

segment_type='TABLE'

and segment_name = 'nome_tabella'

group by segment_name;

SELECT owner,

segment_name,

segment_type,

tablespace_name,

bytes/1048576 MB,

initial_extent,

next_extent,

extents,

pct_increase

FROM

DBA_SEGMENTS

WHERE

OWNER = 'BILL'

AND  SEGMENT_NAME = 'nome_tabella'

AND SEGMENT_TYPE = 'TABLE';

select segment_name,segment_type,bytes/1024/1024 MB

from dba_segments

where segment_type='TABLE'

and segment_name='nome_tabella';

select table_name, num_rows, AVG_ROW_LEN , num_rows*AVG_ROW_LEN/1024/1024 space_in_MB

from dba_tables

where table_name = 'nome_tabella'