Thanks a lot for this explanation,
yeah we are doing many massive update and insert in our databases.
--
Thomas Raso
2007/10/30, Augusto Bott <[EMAIL PROTECTED]>:
>
> One possible explanation (possibly not the only one): if you do a
> massive update on the master, that transaction would need to
One possible explanation (possibly not the only one): if you do a
massive update on the master, that transaction would need to create
many blocks of versioned data. If you roll that transaction back,
those blocks will be freed to be reused, but the datafiles won't
shrink.
Since that transaction wa
