save the status of schema and gather all stat of schemas again.

beatony發表於2012-01-17
AI

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部落格 ” ，連結：http://blog.itpub.net/22578826/viewspace-715018/，如需轉載，請註明出處，否則將追究法律責任。

相關文章