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 11.2.0.4 and laterOracle 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.
Symptoms
- 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 12.1.0.2.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
Cause
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
| Symptoms |
| Cause |
| Solution |