DB Replay Report for
DBR_REPLAY_100
| DB Name |
DB Id |
Release |
RAC |
Replay Name |
Replay Status |
| ORCL |
1166960197 |
11.1.0.6.0 |
NO |
DBR_REPLAY_100 |
COMPLETED |
Replay Information
|
Information
|
Replay
|
Capture
|
|
Name
|
DBR_REPLAY_100 |
DBR_CAPTURE_100 |
|
Status
|
COMPLETED |
COMPLETED |
|
Database Name
|
ORCL |
ORCL |
|
Database Version
|
11.1.0.6.0 |
11.1.0.6.0 |
|
Start Time
|
26-MAY-08 16:44:48 |
23-MAY-08 16:49:35 |
|
End Time
|
26-MAY-08 16:45:57 |
23-MAY-08 16:52:05 |
|
Duration
|
1 minute 9 seconds |
2 minutes 30 seconds |
|
Directory Object
|
DBRCONTROL |
DBRCONTROL |
|
Directory Path
|
/home/oracle/DBRControl |
/home/oracle/DBRControl |
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
|
152.646 seconds
|
143.183 seconds
|
|
Average Active Sessions
|
2.21 |
.95 |
|
User calls
|
440 |
496 |
|
Network Time
|
0.019 seconds
|
.
|
|
Think Time
|
0.996 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 |
| CPU + Wait for CPU |
CPU |
52.94 |
| buffer deadlock |
Other |
11.76 |
| db file sequential read |
User I/O |
5.88 |
Top Service/Module/Action
| Service Name |
Module Name |
% Activity |
Action Drilldown |
| BATCH_STD |
LoadGenerator |
47.06 |
| Action Name |
% Activity |
| BuildInvoiceDetail |
47.06 |
|
| BATCH_LOW |
LoadGenerator |
17.65 |
| Action Name |
% Activity |
| BuildInvoiceDetail |
17.65 |
|
| DSS |
wrc@11gR1NF (TNS V1-V3) |
5.88 |
| Action Name |
% Activity |
| UNNAMED |
5.88 |
|
Top SQL with Top Events
| SQL ID |
Planhash |
Sampled Number of Executions |
% Activity |
Event Drilldown |
| 0wvttswphs2ky |
0 |
2 |
23.53 |
| Event |
% Activity |
| CPU + Wait for CPU |
23.53 |
|
| 4ymp71aaj3bud |
0 |
1 |
17.65 |
| Event |
% Activity |
| CPU + Wait for CPU |
17.65 |
|
| 1bshjy696nrzg |
0 |
1 |
11.76 |
| Event |
% Activity |
| CPU + Wait for CPU |
11.76 |
|
| 1dmv3vasxtjtu |
2076861007 |
2 |
11.76 |
| Event |
% Activity |
| buffer deadlock |
11.76 |
|
| 5qgz1p0cut7mx |
0 |
0 |
5.88 |
| Event |
% Activity |
| db file sequential read |
5.88 |
|
Top Sessions with Top Events
| Session ID |
Session Serial |
Username |
Program |
% Activity |
Event Drilldown |
| 99 |
20 |
SH |
wrc@11gR1NF (TNS V1-V3) |
17.65 |
| Event |
% Activity |
| CPU + Wait for CPU |
11.76 |
| buffer deadlock |
5.88 |
|
| 106 |
15 |
OE |
wrc@11gR1NF (TNS V1-V3) |
17.65 |
| Event |
% Activity |
| CPU + Wait for CPU |
11.76 |
| buffer deadlock |
5.88 |
|
| 123 |
115 |
OE |
wrc@11gR1NF (TNS V1-V3) |
17.65 |
| Event |
% Activity |
| CPU + Wait for CPU |
17.65 |
|
| 104 |
18 |
OE |
wrc@11gR1NF (TNS V1-V3) |
11.76 |
| Event |
% Activity |
| CPU + Wait for CPU |
11.76 |
|
| 111 |
874 |
SH |
wrc@11gR1NF (TNS V1-V3) |
5.88 |
| Event |
% Activity |
| db file sequential read |
5.88 |
|
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.
