dba 学习网站

http://www.hellodba.com/index.php?class=doc&lang=cn

http://www.jiagulun.com/thread-57-1-17.html

 

SET VERIFY OFF 
SET FEEDBACK OFF 
SET SERVEROUTPUT ON SIZE 1000000 
 
execute dbms_stats.gather_schema_stats(OWNNAME => 'schema_name', ptions => 'GATHER', estimate_percent => dbms_stats.auto_sample_size, method_opt => 'FOR ALL COLUMNS SIZE AUTO', CASCADE => TRUE); 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/235507/viewspace-715301/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/235507/viewspace-715301/