Log archival / retrieval is performed by a single thread. This can lead to log archival stuck e.g. if log file need to be retrieved to be added to online backup include logs.
This is also problematic if multiple log files need to be retrieved during database rollforward. This gets even worse if log file are compressed. The time for decompression (non HW accelerated) is that high that rollforward can get stuck easily. Parallel retrieval and therefore parallel decompression would eliminate this bottleneck.
Why is it useful?
|Who would benefit from this IDEA?|
How should it work?