During a live reorganization, excessive archive logs are generated even when Unrecoverable is selected.
Excessive redo log generation occurs during the secondary index creation phase of a reorg job. When there is no activity on the table being reorganized and the indexes take a substantial time to create, the posting thread is cycling, that is checking for updates, and updating an internal QSA table (QUEST_QSA_LWSES< object id> table) that it uses to keep track of posting activity. When there is no posting activity, the updates to the LWSES table causes noticeable redo. For example, it is possible to measure more than 1,000 updates per minute.
WORKAROUND:
None
STATUS:
Issue fixed in version 6.2. The latest version of Space Manager with LiveReorg can be downloaded at: http://support.quest.com/support_download/Downloads.asp
With version 6.2, the change implemented is to check after each posting cycle, and if there have been no updates, to sleep a second before resuming. The result is that instead of 1,000 posting cycles per minute there will be at most 60; this results in a dramatic reduction in the redo activity due to the QUEST_QSA_LWSES<object id> table.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy