Task Information:                                            Workload Information:
 ---------------------------------------------                ---------------------------------------------
  Task Name    : TASK_69                                       SQL Tuning Set Name        : STS_SPA_100
  Task Owner   : SYS                                           SQL Tuning Set Owner       : SYS
  Description  : Comparison of LDGN-executed SQL statements    Total SQL Statement Count  : 8

Execution Information:
---------------------------------------------------------------------------------------------
  Execution Name  : SPA_110_PC                        Started             : 10/18/2007 21:59:53
  Execution Type  : COMPARE PERFORMANCE               Last Updated        : 10/18/2007 21:59:54
  Description     : SPA 110 Performance Comparison    Global Time Limit   : UNLIMITED
  Scope           : COMPREHENSIVE                     Per-SQL Time Limit  : UNUSED
  Status          : COMPLETED                         Number of Errors    : 0

Analysis Information:
---------------------------------------------------------------------------------------------
 Comparison Metric: ELAPSED_TIME
 ------------------
 Workload Impact Threshold: 1%
 --------------------------
 SQL Impact Threshold: 1%
 ----------------------
 Before Change Execution:                        After Change Execution:
 ---------------------------------------------  ---------------------------------------------
  Execution Name      : SQR_BEFORE_110           Execution Name      : SQR_AFTER_110
  Execution Type      : TEST EXECUTE             Execution Type      : TEST EXECUTE
  Description         : Before-image changes     Description         : After-image replay
  Scope               : COMPREHENSIVE            Scope               : COMPREHENSIVE
  Status              : COMPLETED                Status              : COMPLETED
  Started             : 10/18/2007 21:36:10      Started             : 10/18/2007 21:38:56
  Last Updated        : 10/18/2007 21:36:14      Last Updated        : 10/18/2007 21:38:59
  Global Time Limit   : UNLIMITED                Global Time Limit   : UNLIMITED
  Per-SQL Time Limit  : UNLIMITED                Per-SQL Time Limit  : UNLIMITED

Number of Errors    : 0                        Number of Errors    : 0

Report Summary
---------------------------------------------------------------------------------------------

Projected Workload Change Impact:
-------------------------------------------
 Overall Impact      :  55.3%
 Improvement Impact  :  57.42%
 Regression Impact   :  -2.12%

SQL Statement Count
-------------------------------------------
 SQL Category  SQL Count  Plan Change Count
 Overall               8                  4
 Improved              4                  2
 Regressed             1                  1
 Unchanged             3                  1

Projected Workload Performance Distribution
--------------------------------------------------------------------
|          | Cumulative Perf. |        | Cumulative Perf. |        |
| Bucket   | Before Change    | (%)    | After Change     | (%)    |
--------------------------------------------------------------------
| < = 1    |                0 |     0% |                1 |   .07% |
| < = 4    |                4 |   .12% |                0 |     0% |
| < = 8    |                6 |   .18% |                5 |   .33% |
| < = 16   |               12 |   .35% |               16 |  1.06% |
| < = 128  |               82 |  2.41% |              264 | 17.43% |
| < = 256  |              243 |  7.15% |                0 |     0% |
| < = 512  |                0 |     0% |              402 | 26.53% |
| < = 1024 |              646 | 19.01% |              827 | 54.59% |
| < = 2048 |             2405 | 70.78% |                0 |     0% |
--------------------------------------------------------------------

Single SQL Statement Execution Count Distribution
-----------------------------------------------------------
|          | SQL Count     |       | SQL Count    |        |
| Bucket   | Before Change | (%)   | After Change | (%)    |
-----------------------------------------------------------
| < = 1    |             0 |    0% |            1 | 12.5%  |
| < = 4    |             1 | 12.5% |            0 |    0%  |
| < = 8    |             1 | 12.5% |            1 | 12.5%  |
| < = 16   |             1 | 12.5% |            1 | 12.5%  |
| < = 128  |             1 | 12.5% |            3 | 37.5%  |
| < = 256  |             1 | 12.5% |            0 |    0%  |
| < = 512  |             0 |    0% |            1 | 12.5%  |
| < = 1024 |             1 | 12.5% |            1 | 12.5%  |
| < = 2048 |             2 |   25% |            0 |    0%  |
-----------------------------------------------------------

SQL Statements Sorted by their Absolute Value of Change Impact on the Workload
-------------------------------------------------------------------------------------------------------
|           |
| Impact on | Metric        | Metric    |     Impact      |%Workload| % Workload             | Plan   |
| object_id | sql_id        | Workload  | Before | After  | on SQL | Before     | After      | Change |
-------------------------------------------------------------------------------------------------------
|        19 | 8wvwzmntz1y6d |    37.88% |   1292 |      5 | 99.61% |     38.02% |       .33% | y      |
|        20 | 7rhxkp8kaqj4n |     8.42% |   1113 |    827 |  25.7% |     32.75% |     54.59% | n      |
|        21 | c8umkcxmm8mhd |     7.18% |    646 |    402 | 37.77% |     19.01% |     26.53% | n      |
|        18 | 5pkmwau93fq58 |     3.94% |    243 |    109 | 55.14% |      7.15% |      7.19% | y      |
|        25 | 50ypu8mhq5q27 |    -2.12% |     12 |     84 |  -600% |       .35% |      5.54% | y      |
-------------------------------------------------------------------------------------------------------