How to Disable Parallel Transaction Recovery When Parallel Txn Recovery is Active
(Doc ID 238507.1)
Last updated on AUGUST 04, 2018
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!