SQL> /
DBMS_WORKLOAD_REPLAY.REPORT(REPLAY_ID=>1,FORMAT=>'HTML')
--------------------------------------------------------------------------------
DB Replay Report
DB Replay Report for
replay1
DB Name |
DBMS_WORKLOAD_REPLAY.REPORT(REPLAY_ID=>1,FORMAT=>'HTML')
--------------------------------------------------------------------------------
DB Id |
Release |
RAC |
Replay Name |
Replay Status |
PWHD |
4252952393 |
11.1.0.6.0 |
NO |
replay1 |
COMPLETED |
Replay Information
Information
|
Replay
|
Capture
|
Name
|
replay1 |
capture1 |
Status
|
COMPLETED |
COMPLETED |
Database Name
|
PWHD |
PWHD |
Database Version
|
11.1.0.6.0 |
11.1.0.6.0 |
Start Time
|
13-NOV-11 14:21:42 |
13-NOV-11 14:04:16 |
End Time
|
13-NOV-11 14:22:05 |
13-NOV-11 14:04:37 |
Duration
|
23 seconds |
21 seconds |
Directory Object
|
DBREPLAY |
DBREPLAY |
Directory Path
|
c:\dbreplay1 |
c:\dbreplay1 |
DBMS_WORKLOAD_REPLAY.REPORT(REPLAY_ID=>1,FORMAT=>'HTML')
--------------------------------------------------------------------------------
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
|
1.616 seconds
|
0.040 seconds
|
Average Active Sessions
|
.07 |
0 |
User calls
|
29 |
29 |
Network Time
|
0.000 seconds
DBMS_WORKLOAD_REPLAY.REPORT(REPLAY_ID=>1,FORMAT=>'HTML')
--------------------------------------------------------------------------------
|
.
|
Think Time
|
5.834 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
No data exists for this section of the report.
|
Top Service/Module/Action
No data exists for this section of the report.
|
Top SQL with Top Events
No data exists for this section of the report.
|
Top Sessions with Top Events
No data exists for this section of the report.
|
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
(+) Show
DBMS_WORKLOAD_REPLAY.REPORT(REPLAY_ID=>1,FORMAT=>'HTML')
--------------------------------------------------------------------------------
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
DBMS_WORKLOAD_REPLAY.REPORT(REPLAY_ID=>1,FORMAT=>'HTML')
--------------------------------------------------------------------------------
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.
SQL> spool off