首先找出一個表每行的平均長度,如下:
SQL> exec dbms_stats.gather_table_stats(user,'bc_lab',cascade => true);
PL/SQL procedure successfully completed
SQL> select AVG_ROW_LEN from user_tables where table_name='BC_LAB';
AVG_ROW_LEN
-----------
79
其次預估表會有多少行,再進行計算:表容量=79 bytes * N;