반응형
select 
        table_name, 
        num_rows,
        num_rows * avg_row_len, 
        avg_row_len,
        round((num_rows * avg_row_len/1024/1024),2) "SIZE(Mb)", 
        round((num_rows * avg_row_len/1024/1024/1024),2) "SIZE(Gb)",
        last_analyzed
from user_tables
where table_name='테이블 네임'

+ Recent posts