save the status of schema and gather all stat of schemas again.
Hi Tony/Jerry,
1. Please save the current stats for OTC_WRHS_POSITION schema
2. Please gather all stats for OTC_WRHS_POSITION schema at 100%
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1. 备份一个数据库 schema 的所有对象的执行计划：
SQL> execute DBMS_STATS.create_stat_table('OTC_WRHS_POSITION','OTC_WRHS_STAT_20120116');
PL/SQL procedure successfully completed.
SQL> execute DBMS_STATS.EXPORT_SCHEMA_STATS ('OTC_WRHS_POSITION','OTC_WRHS_STAT_20120116');
PL/SQL procedure successfully completed.
2. 分析schema 下的所有对象.<gather all stats for OTC_WRHS_POSITION schema at 100%>
I am now trying to use script. for analyze ,as it may takes a long time
would you please tell me on which node I can run following script?
dba_oracle_analyze -s O02OTC3 -o OTC_WRHS_POSITION -p 100 -D 8
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-715018/ ，如需转载，请注明出处，否则将追究法律责任。
