Managing Statistics
gather_table_stats
gather_index_stats
gather_schema_stats
gather_database_stats
gather_stale_stats
Gather Statistics
SQL> insert into ta values(3,'booboo');
1 row created.
SQL> commit;
SQL> select num_rows, blocks from dba_tables where owner='SYS' and table_name='TA';
no rows selected
SQL> exec dbms_stats.gather_table_stats('sys','ta');
PL/SQL procedure successfully comp