How to Disable Parallel Transaction Recovery When Parallel Txn Recovery is Active
Last updated on NOVEMBER 14, 2016
Applies to:Oracle Database - Personal Edition - Version 184.108.40.206 to 220.127.116.11 [Release 8.1.5 to 12.1]
Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.5 to 12.1]
Information in this document applies to any platform.
Parallel Transaction Recovery is taking too long.
You can use V$TRANSACTION USED_UBLK to estimate how long the rollback is going
to take but there is no formula for this. If you shutdown the database after
rollback has started, it will begin where it left off.
You can also look at V$FAST_START_TRANSACTIONS for UNDOBLOCKSDONE
A large transaction got killed or rolled back.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms