Hi,
Trying to get a rationale why I would want a fixed width ai extent when ai archiver is enabled.
Extents are emptied during the rotation, so why would I set it at fixed width?
Even with the archiver disabled, can you not script it so that it empties the active extent at the time the script runs?
AI extents won't grow large with the constant emptying, so what's the point in setting a fixed width extent?
TIA!
OE 11.3
You *might* use fixed length extents if you have a very, very high transaction volume and you have demonstrated (by actually testing it) that you can get a performance benefit that way.
That's the only reason I can think of why I would do it.
So far I have not found a case where I would go that route.
I find variable length after-image extents to be much simpler to manage.
> On Feb 6, 2020, at 6:13 AM, ChUIMonster wrote:
>
> I find variable length after-image extents to be much simpler to manage.
>
>
>
you do not have to calculate in advance exactly how much disk space to allocate for after-image extents. if you do, and you are wrong, or conditions change, trouble ensues.