DB Replay Report for Monatstipp_Replay2 --------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------- | DB Name | DB Id | Release | RAC | Replay Name | Replay Status | ------------------------------------------------------------------------------- | O11G | 135170020 | 11.1.0.6.0 | NO | Monatstipp_Replay2 | COMPLETED | ------------------------------------------------------------------------------- Replay Information ------------------------------------------------------------------- | Information | Replay | Capture | ------------------------------------------------------------------- | Name | Monatstipp_Replay2 | Monatstipp | ------------------------------------------------------------------- | Status | COMPLETED | COMPLETED | ------------------------------------------------------------------- | Database Name | O11G | O10G | ------------------------------------------------------------------- | Database Version | 11.1.0.6.0 | 10.2.0.4.0 | ------------------------------------------------------------------- | Start Time | 03-NOV-08 11:36:18 | 29-SEP-08 10:42:43 | ------------------------------------------------------------------- | End Time | 03-NOV-08 12:06:26 | 29-SEP-08 11:12:45 | ------------------------------------------------------------------- | Duration | 29 minutes 58 seconds | 30 minutes 2 seconds | ------------------------------------------------------------------- | Directory Object | DB_WORKLOAD_DIR | DB_WORKLOAD_DIR | ------------------------------------------------------------------- | Directory Path | C:\temp\oracle | C:\temp\oracle | ------------------------------------------------------------------- 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 | 23.813 seconds | 227.845 seconds | ---------------------------------------------------------------- | Average Active Sessions | ,01 | ,13 | ---------------------------------------------------------------- | User calls | 3088 | 3088 | ---------------------------------------------------------------- | Network Time | 28.862 seconds | . | ---------------------------------------------------------------- | Think Time | 6055.595 seconds | . | ---------------------------------------------------------------- Replay Divergence Summary ------------------------------------------------------------------- | Divergence Type | Count | % Total | ------------------------------------------------------------------- | Session Failures During Replay | 0 | 0.00 | ------------------------------------------------------------------- | Errors No Longer Seen During Replay | 1 | 0.03 | ------------------------------------------------------------------- | New Errors Seen During Replay | 24 | 0.78 | ------------------------------------------------------------------- | Errors Mutated During Replay | 347 | 11.24 | ------------------------------------------------------------------- | DMLs with Different Number of Rows Modified | 13 | 0.42 | ------------------------------------------------------------------- | SELECTs with Different Number of Rows Fetched | 4 | 0.13 | ------------------------------------------------------------------- --------------------------------------------------------------------------------------------------- Workload Profile Top Events ------------------------------------------------- | Event | Event Class | % Activity | ------------------------------------------------- | CPU + Wait for CPU | CPU | 100.00 | ------------------------------------------------- Top Service/Module/Action --------------------------------------------------------------------------------------------------- | Service Name | Module Name | % Activity | Action Drilldown | --------------------------------------------------------------------------------------------------- | SYS$USERS | OEM.SystemPool | 75.00 | -------------------------------------------------- | | | | | | Action Name | % Activity | | | | | | -------------------------------------------------- | | | | | | UNNAMED | 75.00 | | | | | | -------------------------------------------------- | --------------------------------------------------------------------------------------------------- | SYS$USERS | emagent.exe | 25.00 | -------------------------------------------------- | | | | | | Action Name | % Activity | | | | | | -------------------------------------------------- | | | | | | UNNAMED | 25.00 | | | | | | -------------------------------------------------- | --------------------------------------------------------------------------------------------------- Top SQL with Top Events --------------------------------------------------------------------------------------------------- | SQL ID | Planhash | Sampled Number of | % Activity | Event Drilldown | | | | Executions | | | --------------------------------------------------------------------------------------------------- | cydnuss99swtd | 0 | 2 | 50.00 | ------------------------- | | | | | | | Event | % | | | | | | | | | Activity | | | | | | | ------------------------- | | | | | | | CPU + | 50.00 | | | | | | | | Wait for | | | | | | | | | CPU | | | | | | | | ------------------------- | --------------------------------------------------------------------------------------------------- | 2b064ybzkwf1y | 0 | 1 | 25.00 | ------------------------- | | | | | | | Event | % | | | | | | | | | Activity | | | | | | | ------------------------- | | | | | | | CPU + | 25.00 | | | | | | | | Wait for | | | | | | | | | CPU | | | | | | | | ------------------------- | --------------------------------------------------------------------------------------------------- | 47a8mbdmur7x4 | 1179320878 | 0 | 25.00 | ------------------------- | | | | | | | Event | % | | | | | | | | | Activity | | | | | | | ------------------------- | | | | | | | CPU + | 25.00 | | | | | | | | Wait for | | | | | | | | | CPU | | | | | | | | ------------------------- | --------------------------------------------------------------------------------------------------- Top Sessions with Top Events -------------------------------------------------------------------------------------------------- | Session ID | Session Serial | Username | Program | % Activity | Event Drilldown | -------------------------------------------------------------------------------------------------- | 126 | 312 | SYSMAN | wrc.exe | 50.00 | --------------------- | | | | | | | | Event | % | | | | | | | | | | Activity | | | | | | | | --------------------- | | | | | | | | CPU + | 50.00 | | | | | | | | | Wait | | | | | | | | | | for | | | | | | | | | | CPU | | | | | | | | | --------------------- | -------------------------------------------------------------------------------------------------- | 123 | 23 | SYSMAN | wrc.exe | 25.00 | --------------------- | | | | | | | | Event | % | | | | | | | | | | Activity | | | | | | | | --------------------- | | | | | | | | CPU + | 25.00 | | | | | | | | | Wait | | | | | | | | | | for | | | | | | | | | | CPU | | | | | | | | | --------------------- | -------------------------------------------------------------------------------------------------- | 124 | 20 | DBSNMP | wrc.exe | 25.00 | --------------------- | | | | | | | | Event | % | | | | | | | | | | Activity | | | | | | | | --------------------- | | | | | | | | CPU + | 25.00 | | | | | | | | | Wait | | | | | | | | | | for | | | | | | | | | | CPU | | | | | | | | | --------------------- | -------------------------------------------------------------------------------------------------- Replay Divergence Session Failures By Application -------------------------------------------------- | No data exists for this section of the report. | -------------------------------------------------- Error Divergence By Application --------------------------------------------------------------------------------------------- | Service | Module | Action | Capture | Replay | Count | First Occ | Last Occu | | Name | Name | Name | Error | Error | | urrence | rrence | --------------------------------------------------------------------------------------------- | SYS$USERS | emagent.e | UNNAMED | ORA-25228 | ORA-15566 | 347 | 2008-11-0 | 2008-11-0 | | | xe | | | | | 3T11:48:4 | 3T12:05:1 | | | | | | | | 5.718000+ | 1.875000+ | | | | | | | | 02:00 | 02:00 | --------------------------------------------------------------------------------------------- | SYS$USERS | OEM.Bound | UNNAMED | Successfu | ORA-06550 | 11 | 2008-11-0 | 2008-11-0 | | | edPool | | l | | | 3T11:42:2 | 3T12:05:1 | | | | | | | | 8.921000+ | 8.578000+ | | | | | | | | 02:00 | 02:00 | --------------------------------------------------------------------------------------------- | SYS$USERS | OEM.Loade | XMLLoader | Successfu | ORA-00001 | 6 | 2008-11-0 | 2008-11-0 | | | r | 0 | l | | | 3T11:52:2 | 3T12:52:3 | | | | | | | | 9.843000+ | 0.031000+ | | | | | | | | 02:00 | 02:00 | --------------------------------------------------------------------------------------------- | SYS$USERS | OEM.Bound | UNNAMED | Successfu | ORA-20613 | 6 | 2008-11-0 | 2008-11-0 | | | edPool | | l | | | 3T11:53:2 | 3T11:57:1 | | | | | | | | 9.625000+ | 8.953000+ | | | | | | | | 02:00 | 02:00 | --------------------------------------------------------------------------------------------- | SYS$USERS | OEM.Loade | XMLLoader | ORA-00001 | Successfu | 1 | 2008-11-0 | 2008-11-0 | | | r | 0 | | l | | 3T12:00:2 | 3T12:04:2 | | | | | | | | 1.750000+ | 1.750000+ | | | | | | | | 02:00 | 02:00 | --------------------------------------------------------------------------------------------- | SYS$USERS | OEM.Bound | UNNAMED | Successfu | ORA-20249 | 1 | 2008-11-0 | 2008-11-0 | | | edPool | | l | | | 3T12:01:2 | 3T12:01:2 | | | | | | | | 8.906000+ | 8.906000+ | | | | | | | | 02:00 | 02:00 | --------------------------------------------------------------------------------------------- By SQL ------------------------------------------------------------------------------------------------ | SQL ID | Capture Error | Replay Error | Count | First | Last Occurrence | | | | | | Occurrence | | ------------------------------------------------------------------------------------------------ | 8hk7xvhua40va | Successful | ORA-00001 | 6 | 2008-11-03T11:5 | 2008-11-03T11:5 | | | | | | 2:29.843000+02: | 2:30.031000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ | ckd6kpty9npxk | Successful | ORA-06550 | 6 | 2008-11-03T11:4 | 2008-11-03T12:0 | | | | | | 1:28.921000+02: | 1:18.578000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ | 0rsp9pkbtccnm | Successful | ORA-06550 | 5 | 2008-11-03T11:3 | 2008-11-03T11:3 | | | | | | 8:29.984000+02: | 9:39.546000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ | cmjf0y5s3t51t | Successful | ORA-20613 | 4 | 2008-11-03T11:4 | 2008-11-03T11:5 | | | | | | 6:29.625000+02: | 8:18.953000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ | f787fyhjmkp61 | Successful | ORA-20613 | 2 | 2008-11-03T11:5 | 2008-11-03T12:0 | | | | | | 9:56.531000+02: | 5:00.281000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ | 4vvuzs84f1mvr | ORA-00001 | Successful | 1 | 2008-11-03T11:5 | 2008-11-03T14:5 | | | | | | 0:21.750000+02: | 0:21.750000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ | bgb6m4jc3rps0 | Successful | ORA-20249 | 1 | 2008-11-03T12:4 | 2008-11-03T12:4 | | | | | | 1:28.906000+02: | 1:28.906000+02: | | | | | | 00 | 00 | ------------------------------------------------------------------------------------------------ By Session ------------------------------------------------------------------------------------------------- | Session ID | Session | Capture | Replay Error | Count | First | Last | | | Serial | Error | | | Occurrence | Occurrence | ------------------------------------------------------------------------------------------------- | 128 | 786 | ORA-25228 | ORA-15566 | 347 | 2008-11-03T1 | 2008-11-03T1 | | | | | | | 1:38:45.7180 | 2:05:11.8750 | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | 120 | 256 | Successful | ORA-06550 | 11 | 2008-11-03T1 | 2008-11-03T1 | | | | | | | 1:37:28.9210 | 2:02:18.5780 | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | 120 | 256 | Successful | ORA-20613 | 6 | 2008-11-03T1 | 2008-11-03T1 | | | | | | | 1:41:29.6250 | 2:03:18.9530 | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | 125 | 16 | Successful | ORA-00001 | 6 | 2008-11-03T1 | 2008-11-03T1 | | | | | | | 1:52:29.8430 | 1:57:30.0310 | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | 120 | 256 | Successful | ORA-20249 | 1 | 2008-11-03T1 | 2008-11-03T1 | | | | | | | 2:01:28.9060 | 2:01:28.9060 | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | 125 | 16 | ORA-00001 | Successful | 1 | 2008-11-03T1 | 2008-11-03T1 | | | | | | | 2:00:21.7500 | 2:00:21.7500 | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- DML Data Divergence By Application ------------------------------------------------------------------------------------------------- | Service | Module | Action | Avg Rows | Avg | Number | Count | First Oc | Last Occ | | Name | Name | Name | Affected | Absolute | of | | currence | urrence | | | | | | Rows | Distinct | | | | | | | | | Affected | Sessions | | | | ------------------------------------------------------------------------------------------------- | SYS$USER | OEM.Load | XMLLoade | -10,1 | 10,4 | 1 | 7 | 2008-11- | 2008-11- | | S | er | r0 | | | | | 03T11:52 | 03T12:00 | | | | | | | | | :29.8430 | :21.7500 | | | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | SYS$USER | OEM.Boun | UNNAMED | -1 | 1 | 1 | 6 | 2008-11- | 2008-11- | | S | dedPool | | | | | | 03T12:01 | 03T12:04 | | | | | | | | | :29.6250 | :18.9530 | | | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- By SQL --------------------------------------------------------------------------------------------------- | SQL ID | Avg Rows | Avg Absolute | Number of | Count | First | Last | | | Affected | Rows | Distinct | | Occurrence | Occurrence | | | | Affected | Sessions | | | | --------------------------------------------------------------------------------------------------- | 8hk7xvhua40v | -12 | 12 | 1 | 6 | 2008-11-03T1 | 2008-11-03T1 | | a | | | | | 1:52:29.8430 | 1:52:30.0310 | | | | | | | 00+02:00 | 00+02:00 | --------------------------------------------------------------------------------------------------- | cmjf0y5s3t51 | -1 | 1 | 1 | 4 | 2008-11-03T1 | 2008-11-03T1 | | t | | | | | 1:38:29.6250 | 1:42:18.9530 | | | | | | | 00+02:00 | 00+02:00 | --------------------------------------------------------------------------------------------------- | f787fyhjmkp6 | -1 | 1 | 1 | 2 | 2008-11-03T1 | 2008-11-03T1 | | 1 | | | | | 2:03:56.5310 | 2:05:00.2810 | | | | | | | 00+02:00 | 00+02:00 | --------------------------------------------------------------------------------------------------- | 4vvuzs84f1mv | 1 | 1 | 1 | 1 | 2008-11-03T1 | 2008-11-03T1 | | r | | | | | 2:00:21.7500 | 2:00:21.7500 | | | | | | | 00+02:00 | 00+02:00 | --------------------------------------------------------------------------------------------------- SELECT Data Divergence By Application ------------------------------------------------------------------------------------------------- | Service | Module | Action | Avg Rows | Avg | Number | Count | First Oc | Last Occ | | Name | Name | Name | Affected | Absolute | of | | currence | urrence | | | | | | Rows | Distinct | | | | | | | | | Affected | Sessions | | | | ------------------------------------------------------------------------------------------------- | SYS$USER | wrc.exe | UNNAMED | -4,5 | 4,5 | 1 | 2 | 2008-11- | 2008-11- | | S | | | | | | | 03T11:42 | 03T11:51 | | | | | | | | | :13.9840 | :39.0460 | | | | | | | | | 00+02:00 | 00+02:00 | ------------------------------------------------------------------------------------------------- | SYS$USER | emagent. | UNNAMED | -3,5 | 4,5 | 1 | 2 | 2008-11- | 2008-11- | | S | exe | | | | | | 03T11:57 | 03T11:59 | | | | | | | | | :34.2180 | :32.4840 | | | | | | | | | 00+02:00 | 00+02:00 | -------------------------------------------------------------------------------------------------