DB Replay Report
End of Report.
DB Replay Report for
| DB Name |
DB Id |
Release |
RAC |
Replay Name |
Replay Status |
|
|
|
|
|
|
|
Replay Information
|
Information
|
Replay
|
Capture
|
|
Name
|
|
|
|
Status
|
|
|
|
Database Name
|
|
|
|
Database Version
|
|
|
|
Error Code
|
|
|
|
Error Message
|
|
|
|
Start Time
|
|
|
|
End Time
|
|
|
|
Duration
|
|
|
|
Directory Object
|
|
|
|
Directory Path
|
|
|
|
AWR DB Id
|
|
|
|
AWR Begin Snap Id
|
|
|
|
AWR End Snap Id
|
|
|
|
PL/SQL Mode
|
|
|
|
Encryption Algorithm
|
|
|
|
Replay Directory Number
|
|
N/A
|
|
Consolidated Replay
|
|
Replay Schedule Information
Schedule
contains
captures:
capture:
|
Information
|
Capture
|
| Name |
|
| Status |
|
| Database Name |
|
| Database Version |
|
| Start Time |
|
| End Time |
|
| Duration |
|
| DB Time |
|
| User Calls |
|
| Average Active Sessions |
|
| Directory Object |
|
| Directory Path |
|
| Start Delay |
second
seconds
|
| Query Only |
|
Replay Schedule Ordering Information
|
Schedule Cap#
|
Waitfor Cap#
|
|
|
|
|
|
|
Replay Options
|
Option Name
|
Value
|
|
Synchronization
|
|
|
Connect Time
|
%
|
|
Connect Time Auto Correct
|
|
|
Think Time
|
%
|
|
Think Time Auto Correct
|
|
|
Query Only
|
|
|
Number of WRC Clients
|
( Completed,
0
Running
)
|
|
Scale Up Multiplier
|
|
Replay Statistics
|
Statistic
|
Replay
|
Capture
Consolidated Captures
|
|
DB Time
|
|
|
|
PL/SQL DB Time
|
|
|
|
User calls
|
|
|
|
PL/SQL user calls
|
|
|
|
PL/SQL subcalls
|
N/A
|
|
|
Average Active Sessions
|
|
|
|
Capture Files
|
/
|
|
|
Finished Replay Sessions
|
|
|
|
Ongoing Replay Sessions
|
|
N/A
|
Replay Divergence Summary
Consolidated Replay Divergence Summary
Capture :
Total Workload
|
Divergence Type
|
Count
|
% Total
|
|
Session Failures During Replay
|
|
|
|
Errors No Longer Seen During Replay
|
|
|
|
New Errors Seen During Replay
|
|
|
|
Errors Mutated During Replay
|
|
|
|
DMLs with Different Number of Rows Modified
|
|
|
|
SELECTs with Different Number of Rows Fetched
|
|
|
Table of Contents
Progress of Commits used for Synchronization
Top Events
Top SQL with Top Events
Top Service/Module
Top Sessions with Top Events
Replay Session Top Events
Top Slowest Replay Sessions
Top Fastest Replay Sessions
Replay Session Top Events
Top Slowest Replay Sessions
Top Fastest Replay Sessions
Next Commit
Replay Sessions Blocking Chain
Replay Critical Path Profile
Top Events
Top SQL with Top Events
|
No data exists for this section of the report.
|
#anchor_
anchor_
(+) Session ID: Session Serial#
#anchor_
anchor_
(-) Session ID: Session Serial#
| Instance ID |
Session ID |
Session Serial# |
SPID |
Event |
File Name |
File ID |
Call Counter |
Seconds in Wait |
|
|
|
|
|
|
|
|
|
is blocked by
| Instance ID |
Session ID |
Session Serial# |
SPID |
Event |
File Name |
File ID |
Call Counter |
|
|
|
|
|
|
|
|
Consolidated Replay Divergence
Capture :
Session Failures
Error Divergence
DML Data Divergence
SELECT Data Divergence
By Application
By Error
By Application
By SQL
By Application
By SQL
By Application
999999999999999999999990
999999999999999999999990.0
999999999999999999999990.00
999999999999999999999990.000
#anchor_
anchor_
(+) Show
#anchor_
anchor_
(-) Hide
No data exists for this section of the report.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
row
row
row
|
|
|
|
|
|
|
|
|
|
|