exec DBMS_STATS.CREATE_STAT_TABLE (ownname=>'GYJ', stattab=>'STAT_TAB',tblspace=>'STAT_TP1');
2.导出备份统计信息:
exec dbms_stats.export_table_stats(ownname=>'GYJ',tabname=>'LOG_PREPAY_INFO',stattab=>'STAT_TAB');
3.比如分析过后,发现有问题:
analyze table LOG_PREPAY_INFO compute statistics
for table
for all indexes
for all indexed columns;
4.马上删除:
analyze table LOG_PREPAY_INFO delete statistics;
5.马上导入刚才备份的信息:
exec dbms_stats.import_table_stats(ownname=>'GYJ',tabname=>'LOG_PREPAY_INFO',stattab=>'STAT_TAB');
6.其中列上面的柱状图信息,需要这样删除:
DBMS_STATS.DELETE_COLUMN_STATS (
ownname VARCHAR2,
tabname VARCHAR2,
colname VARCHAR2,
partname VARCHAR2 DEFAULT NULL,
stattab VARCHAR2 DEFAULT NULL,
statid VARCHAR2 DEFAULT NULL,
cascade_parts BOOLEAN DEFAULT TRUE,
statown VARCHAR2 DEFAULT NULL,
no_invalidate BOOLEAN DEFAULT FALSE);
比如:
exec DBMS_STATS.DELETE_COLUMN_STATS(ownname=>'HR',tabname=>'EMPLOYEES',colname=>'STATUS');
**********本博客所有内容均为原创,如有转载请注明作者和出处!!!**********
Name: guoyJoe
QQ: 252803295
Email: oracledba_cn@hotmail.com
Blog: http://blog.csdn.net/guoyJoe
ITPUB: http://www.itpub.net/space-uid-28460966.html
OCM: http://education.oracle.com/education/otn/YGuo.HTM
_____________________________________________________________
加群验证问题:哪些SGA结构是必需的,哪些是可选的?否则拒绝申请!!!
答案在:http://blog.csdn.net/guoyjoe/article/details/8624392
Oracle@Paradise 总群:127149411
Oracle@Paradise No.1群:177089463(已满)
Oracle@Paradise No.2群:121341761
Oracle@Paradise No.3群:140856036