DB Replay Report for REPLAY-ocm11g.yaocm.id.au-20120222152142

DB Name DB Id Release RAC Replay Name Replay Status
OCM11G 3371126031 11.1.0.7.0 NO REPLAY-ocm11g.yaocm.id.au-20120222152142 COMPLETED

Replay Information
Information Replay Capture
Name REPLAY-ocm11g.yaocm.id.au-20120222152142 CAPTURE-ocm11g.yaocm.id.au-20120222114009
Status COMPLETED COMPLETED
Database Name OCM11G OCM11G
Database Version 11.1.0.7.0 11.1.0.7.0
Start Time 22-FEB-12 15:28:41 22-FEB-12 11:48:49
End Time 22-FEB-12 15:30:27 22-FEB-12 11:54:30
Duration 1 minute 46 seconds 5 minutes 41 seconds
Directory Object SH_REPLAY SH_REPLAY
Directory Path /u00/app/oracle/replay/sh /u00/app/oracle/replay/sh

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 57.639 seconds 22.816 seconds
Average Active Sessions .54 .07
User calls 414 414
Network Time 1.160 seconds .
Think Time 0.309 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
read by other session User I/O 25.00
log file sync Commit 12.50
db file sequential read User I/O 12.50
Top Service/Module/Action
(-) Hide
Service Name Module Name % Activity Action Drilldown
SYS$USERS SQL*Plus 37.50
Action Name % Activity
UNNAMED 37.50
ocm11g.yaocm.id.au WRC$ 12.50
Action Name % Activity
UNNAMED 12.50
Top SQL with Top Events
(-) Hide
SQL ID Planhash Sampled Number of Executions % Activity Event Drilldown
dgdfqhj9ua2kv 2491394033 3 37.50
Event % Activity
read by other session 25.00
db file sequential read 12.50
Top Sessions with Top Events
(-) Hide
Session ID Session Serial Username Program % Activity Event Drilldown
117 3882 SYSTEM wrc@bankstown.yaocm.id.au (TNS V1-V3) 12.50
Event % Activity
log file sync 12.50
122 7157 SH wrc@bankstown.yaocm.id.au (TNS V1-V3) 12.50
Event % Activity
read by other session 12.50
131 9679 SH wrc@bankstown.yaocm.id.au (TNS V1-V3) 12.50
Event % Activity
db file sequential read 12.50
170 2502 SH wrc@bankstown.yaocm.id.au (TNS V1-V3) 12.50
Event % Activity
read by other session 12.50
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.
Replay Clients Alerts
(-) Hide
No data exists for this section of the report.

End of Report. 
Servlet error: Internal Error has occured. Check the log file for details.