i have encounted a serious problem that is when i execute alter frament add another fragement it crossover 4Gb Logical log dosen't finish,so it was reached the threshold of LONGTX.but sometimes it was very fast almost 1 seconds to finish.
the sql was:
i don't know why is that,it maybe a bug or something?
table's row size about 8k and dbspace using 8k
table count(*) have over 79,000,000 row
pls help me,thanks!
btw:table have 10,00,000 times insert and 500,000 update a day.index have not fragemnt