SQL> EXEC dbms_stats.gather_table_stats('【username】','【tablename】',cascade=>true);
--單個(gè)表統(tǒng)計(jì)數(shù)據(jù)的統(tǒng)計(jì)數(shù)據(jù)更新
PL/SQL procedure successfully completed
SQL> EXEC dbms_stats.gather_schema_stats('【username】',estimate_percent=>100,cascade=> TRUE);
--更新整個(gè)用戶所有表的統(tǒng)計(jì)數(shù)據(jù)更新