How to Disable Parallel Transaction Recovery When Parallel Txn Recovery is Active
Last updated on MAY 04, 2018
Applies to:Oracle Database - Personal Edition - Version 188.8.131.52 to 184.108.40.206 [Release 8.1.5 to 12.1]
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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