在目标数据库上:
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);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/6906/viewspace-606570/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/6906/viewspace-606570/