How to estimate Table size with new large data before inserting

 

If we are planning to insert large number of data then we have to calculate estimate table size which will be increase after insert.

For that find "avg_row_len"  value of respective table from dba_tables 

select avg_row_len,table_name from dba_tables where table_name like '%Table_name%' ;

Suppose, we are inserting 1 million Data in table then

 

select (avg_row_len*1000000)/1024/1024/1024 GB from dba_tables
where table_name like '%Table_name%'
;