mlog$

--perceived size
select table_name,round((blocks*8),2)||'kb' "size"  from all_tables where table_name = 'MLOG$_MTL_ITEM_CATEGORIES1';

--actual

select table_name,round((num_rows*avg_row_len/1024),2)||'kb' "size" from all_tables where table_name ='MLOG$_MTL_ITEM_CATEGORIES1';


truncate table inv.MLOG$_MTL_ITEM_CATEGORIES1;

exec dbms_stats.gather_table_stats('INV','MLOG$_MTL_ITEM_CATEGORIES1');