Replaying a Workload Capture Results in: Enq: TX - Row Lock Contention or Cancels with an ORA-07445: [kgghtIterNext()] During the Replay when OBJECT_ID is Used as the Synchronization Mode
(Doc ID 2231672.1)
Last updated on AUGUST 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
- The Replay Synchronization mode is: OBJECT_ID
- Executing a Replay for a 60 minute workload captured on 10.2.0.5.0 and replaying on 126.96.36.199.0 results in a large amount of avg wait time for:
- Replay may cancel itself and an ORA-07445: [kgghtIterNext() is logged in the Alert.log
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document