|
|
|
|
|
|
by HarrisonFisk
4648 days 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. |
|
|