|
|
summary,
1) freelist&freelist group and ASSM will make worse cluster_factor
2) analyze index validate structure is not suitable in online active table & big indexes
3) bug of 50-50 index plit during loop insert-commit has been fixed in 10g.
http://oracletoday.blogspot.com/ ... plit-bug-in-9i.html
4) The redo generated by the Coalesce operation is vastly more than that of the rebuild sometimes
5) index range scan could use db file scatter read to warm db_cache in 10g after database is just re-started.
6) build index online still need locks on table in 10g. but not in 11g.
http://yumianfeilong.com/2007/12 ... online-index-build/ |
|
楼主: sir.liang
IP卡
狗仔卡
发表于 2007-1-21 21:45
显身卡
发表于 2008-9-4 15:46
