???????9iR2?????????????DBMS_STATS??????????????????????????????schema??database??????????????????DBA????

????10G?????Oracle???????????????????31???????????Table???????????洢??[DBA|ALL|USER]_TAB_STATS_HISTORY?????;??schema??database????????????????DBA_OPTSTAT_OPERATIONS????У???STATISTICS_LEVEL???????ó?ALL??TYPICAL???Oracle???????ε?????????????????????????????????????DBMS_STATS.PURGE_STATS???????????????????????????????????????????DBMS_STATS.ALERT_STATISTICS_HISTORY_RETENTION???е???????

??????????????????????????

????1??????????????

?????????????????????м??

?????м???????洢??????????????????????洢??????????У???????????????????????м????м????????DBMS_STATS.CREATE_STAT_TABLE??

BEGIN
DBMS_STATS.CREATE_STAT_TABLE(ownname=>??SYSTEM????stattab=>??STAT_TAB????tblspace=>??TOOLS??);
DBMS_OUTPUT.PUT_LINE(??Create table complete!??);
END;
/


?????????????????м??

??????DBMS_STATS.EXPORT_*_STATS??з?????????????????????????????schema??????????

BEGIN
dbms_stats.export_schema_stats(ownname=>??IQUEWEB????stattab=>??STAT_TAB????statid=>??IQUEWEB_20100526????statown=>??SYSTEM??);END;
/


??????iqueweb?????????????м??system.stat_tab???С?

????Export??STAT_TAB

??????exp??expdp????STAT_TAB.

expdp system/****@**** tables=(stat_tab) directory=export dumpfile=expdat.dmp logfile=iqueweb_stat20100526_e.log


????????????expdat.dmp???????????????????