General Information --------------------------------------------------------------------------------------------- Task Information: Workload Information: --------------------------------------------- --------------------------------------------- Task Name : TASK_364 SQL Tuning Set Name : spa_test_sqlset Task Owner : SYS SQL Tuning Set Owner : SYS Description : Total SQL Statement Count : 6 Execution Information: --------------------------------------------------------------------------------------------- Execution Name : EXEC_350 Started : 03/22/2011 13:46:34 Execution Type : COMPARE PERFORMANCE Last Updated : 03/22/2011 13:46:34 Description : Global Time Limit : UNLIMITED Scope : COMPREHENSIVE Per-SQL Time Limit : UNUSED Status : COMPLETED Number of Errors : 0 Number of Unsupported SQL : 1 Analysis Information: --------------------------------------------------------------------------------------------- Before Change Execution: After Change Execution: --------------------------------------------- --------------------------------------------- Execution Name : before_change Execution Name : after_change Execution Type : TEST EXECUTE Execution Type : TEST EXECUTE Scope : COMPREHENSIVE Scope : COMPREHENSIVE Status : COMPLETED Status : COMPLETED Started : 03/22/2011 13:45:55 Started : 03/22/2011 13:46:24 Last Updated : 03/22/2011 13:45:55 Last Updated : 03/22/2011 13:46:25 Global Time Limit : UNLIMITED Global Time Limit : UNLIMITED Per-SQL Time Limit : UNUSED Per-SQL Time Limit : UNUSED Number of Errors : 0 Number of Errors : 0 --------------------------------------------- Comparison Metric: ELAPSED_TIME ------------------ Workload Impact Threshold: 1% -------------------------- SQL Impact Threshold: 1% ---------------------- Report Summary --------------------------------------------------------------------------------------------- Projected Workload Change Impact: ------------------------------------------- Overall Impact : 99.36% Improvement Impact : 99.36% Regression Impact : 0% SQL Statement Count ------------------------------------------- SQL Category SQL Count Plan Change Count Overall 6 5 Improved 5 5 Unsupported 1 0 Top 5 SQL Sorted by Absolute Value of Change Impact on the Workload --------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------- | | | Impact on | Execution | Metric | Metric | Impact | Plan | | object_id | sql_id | Workload | Frequency | Before | After | on SQL | Change | ----------------------------------------------------------------------------------------- | 16 | 2j3dk2hcs8jq5 | 24.25% | 1 | 5651 | 22 | 99.61% | y | | 18 | 7k24y5pdhurxx | 21.33% | 1 | 4977 | 26 | 99.48% | y | | 19 | 7m2wr4twzmrkm | 18.98% | 1 | 4458 | 52 | 98.83% | y | | 20 | 7vbu3057r64r0 | 17.94% | 1 | 4194 | 29 | 99.31% | y | | 21 | fbsgyfwt1q29p | 16.85% | 1 | 3930 | 19 | 99.52% | y | ----------------------------------------------------------------------------------------- Note: time statistics are displayed in microseconds --------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------