資料庫遷移後的統計資訊更新

在目標資料庫上：

TABLE級別：

exec dbms_stats.UNLOCK_TABLE_STATS(ownname => '',tabname => 'PUBLIC_SERVICE');

exec dbms_stats.gather_table_stats(ownname => '',tabname => 'PUBLIC_SERVICE',estimate_percent => null ,method_opt => 'for all indexed columns',degree=>4,CASCADE=>true);

SCHEMA級別：

exec dbms_stats.UNLOCK_SCHEMA_STATS(ownname => 'USER>');

exec dbms_stats.gather_schema_stats(ownname => 'USER>',estimate_percent => null ,method_opt => 'for all indexed columns',degree=>4,CASCADE=>true);

exec dbms_stats.gather_schema_stats(ownname => 'USER>',degree=>4,CASCADE=>true);