> On Nov 3, 2021, at 6:24 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>
> Let's say that there's a big update as part of a migration, and that update times out, and the migration utility
retriesit several times. (Context is that sequence happened through automated utility, and filled the disk, leading to
anunfortunate series of events.)
>
> 1) At what point does WAL from the failed & rolled back operations "go away"? During the next checkpoint? During the
checkpointafter completion of all other transactions which overlapped time-wise with the timing-out ones?
>
WAL file can’t be recycled until it is no longer needed; thus after a checkpoint and archived as well (if enabled).
> 2) Is there a chance that never-visible rows would be written into tables, bloating them?
>
Yes, changes would be recorded into the tables; however, they would not be visible if the transaction was rolled back
oraborted. A subsequent vacuum would remove those records and truncate the file to high water mark if possible.