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