ORACLE表分析

前两天在做数据库存储过程调优的时候，在插入大数据后，用到表分析：
--分析表
   begin
   SYS.DBMS_STATS.gather_table_stats(OWNNAME => 'table_owner',tabname => 'table_name',
                                                   estimate_percent => 10,
                                                   DEGREE  => 5,
                                                   CASCADE => TRUE);

  end;


--分析用户
   begin
   SYS.DBMS_STATS.gather_schema_stats(OWNNAME => 'table_owner',
                                                   estimate_percent => 10,
                                                   DEGREE  => 5,
                                                   CASCADE => TRUE);

  end;