Scripts to Debug Slow Replay
(Doc ID 760402.1)
Last updated on JULY 26, 2023
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
11.1.0.X TO 11.2.0.X
Purpose
The script can be used to debug slow replay as well as to monitor the approximate progress of the replay.
Use this script in conjunction with:
<Document 1287620.1> Database Replay Diagnostic Information
Troubleshooting Steps
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
Purpose |
Troubleshooting Steps |
Requirements |
Configuring |
Instructions |
Scripts |
Query to Obtain Information on Blocking Sessions |
Query to Monitor the Approximate Progress of the Replay |
Query to Provide Summary of Wait Events |
References |