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
(-) Hide
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
(-) Hide
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
(-) Hide
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
(-) Hide
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
(-) Hide
No data exists for this section of the report.
Error Divergence
By Application
(-) Hide
No data exists for this section of the report.
By SQL
(-) Hide
No data exists for this section of the report.
By Session
(-) Hide
No data exists for this section of the report.
DML Data Divergence
By Application
(-) Hide
No data exists for this section of the report.
By SQL
(-) Hide
No data exists for this section of the report.
SELECT Data Divergence
By Application
(-) Hide
No data exists for this section of the report.

End of Report.