610 Blocked is shown for live reorganization scripts.
QSA is waiting for an exclusive lock.
QSA obtains an exclusive lock on a table just before original data is copied to the copy table and just before the switch. In most cases, the lock will be released and the user can continue; however, if it stays too long, a deadlock may occur and Oracle may raise an error.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center