DB Replay Report for
test_capture_2
DB Name |
DB Id |
Release |
RAC |
Replay Name |
Replay Status |
DB11G |
106740077 |
11.1.0.6.0 |
NO |
test_capture_2 |
COMPLETED |
Replay Information
Information
|
Replay
|
Capture
|
Name
|
test_capture_2 |
test_capture_2 |
Status
|
COMPLETED |
COMPLETED |
Database Name
|
DB11G |
DB11G |
Database Version
|
11.1.0.6.0 |
11.1.0.6.0 |
Start Time
|
30-OCT-07 12:03:44 |
30-OCT-07 11:26:49 |
End Time
|
30-OCT-07 12:06:14 |
30-OCT-07 11:31:00 |
Duration
|
2 minutes 30 seconds |
4 minutes 11 seconds |
Directory Object
|
DB_REPLAY_CAPTURE_DIR |
DB_REPLAY_CAPTURE_DIR |
Directory Path
|
/u01/app/oracle/db_replay_capture/ |
/u01/app/oracle/db_replay_capture/ |
Replay Options
Option Name
|
Value
|
Synchronization
|
TRUE |
Connect Time
|
100%
|
Think Time
|
100%
|
Think Time Auto Correct
|
TRUE |
Number of WRC Clients
|
1
(1 Completed,
0
Running
)
|
Replay Statistics
Statistic
|
Replay
|
Capture
|
DB Time
|
14.403 seconds
|
95.714 seconds
|
Average Active Sessions
|
.1 |
.38 |
User calls
|
27 |
31 |
Network Time
|
0.023 seconds
|
.
|
Think Time
|
57.450 seconds
|
.
|
Replay Divergence Summary
Divergence Type
|
Count
|
% Total
|
Session Failures During Replay
|
0 |
0.00 |
Errors No Longer Seen During Replay
|
0 |
0.00 |
New Errors Seen During Replay
|
0 |
0.00 |
Errors Mutated During Replay
|
0 |
0.00 |
DMLs with Different Number of Rows Modified
|
0 |
0.00 |
SELECTs with Different Number of Rows Fetched
|
0 |
0.00 |
Workload Profile
Top Events
Event |
Event Class |
% Activity |
db file sequential read |
User I/O |
33.33 |
Top Service/Module/Action
Service Name |
Module Name |
% Activity |
Action Drilldown |
SYS$USERS |
sqlplus@prod-11g.localdomain (TNS V1-V3) |
33.33 |
Action Name |
% Activity |
UNNAMED |
33.33 |
|
Top SQL with Top Events
No data exists for this section of the report.
|
Top Sessions with Top Events
Session ID |
Session Serial |
Username |
Program |
% Activity |
Event Drilldown |
122 |
1537 |
SYS |
wrc@test-11g.localdomain (TNS V1-V3) |
33.33 |
Event |
% Activity |
db file sequential read |
33.33 |
|
Replay Divergence
Session Failures
By Application
No data exists for this section of the report.
|
Error Divergence
By Application
No data exists for this section of the report.
|
By SQL
No data exists for this section of the report.
|
By Session
No data exists for this section of the report.
|
DML Data Divergence
By Application
No data exists for this section of the report.
|
By SQL
No data exists for this section of the report.
|
SELECT Data Divergence
By Application
No data exists for this section of the report.
|
End of Report.