TAMANO TABLAS

SQL> execute dbms_stats.gather_schema_stats('HR');

PL/SQL procedure successfully completed.

SQL> 

SQL> execute dbms_stats.gather_table_stats('HR','EMPLOYEES');

PL/SQL procedure successfully completed.

SQL> select num_rows, blocks*8192/1024/1024 mb from dba_tables where table_name = 'EMPLOYEES';

  NUM_ROWS    MB

---------- ----------

       107   ,0390625

SQL> select num_rows, blocks*8192/1024/1024 mb from dba_tables where table_name = 'EMPLOYEES';

NUM_ROWS MB

—————————— ——————————

10308870 1522.625