4 ms·
The easiest way is to avoid running into the problem. The main reason the central table space grows is due to rollback segments. To avoid collecting a lot of
by HarrisonFisk 13y ago
The easiest way is to avoid running into the problem.
The main reason the central table space grows is due to rollback segments. To avoid collecting a lot of them there are two tips (in addition to file per table you mentioned):
1. Use multi-threaded purge.
2. Avoid very long running transactions (ie. 12+ hours)
Once we have done that, we don't really see this problem any longer.