SQL Performance Impact Analyzer Report <xsl:if test="report/summary/statements/@category"> - SQL with <xsl:value-of select="report/summary/statements/@category"/> </xsl:if> General Information


Report Summary



Report Details
Task Information:
Workload Information:
Task Name :
Task Owner :
Description :

Execution Information:
Execution Name :
Execution Type :
Description :
Scope :
Status :
Number of Timeouts :
Number of Unsupported SQL :
Started :
Last Updated :
Global Time Limit :
Per-SQL Time Limit :
Number of Errors :
Execution Name :
Execution Type : REMOTE
Database Link :
Scope :
Status :
Started :
Last Updated :
Global Time Limit :
Per-SQL Time Limit :
Number of Errors :
SQL Tuning Set Name :
SQL Tuning Set Owner :
Total SQL Statement Count :

Analysis Information:
Before Change Execution:
After Change Execution:
Before Change Workload:
After Change Workload:
Comparison Metric:
Workload Impact Threshold: %
SQL Impact Threshold: %
Projected Workload Change Impact:
Overall Impact : % % 0%
Improvement Impact : % % 0%
Regression Impact : % % 0%
Missing-SQL Impact : % 0%
New-SQL Impact : % 0%

SQL Statement Count
lime #ff6600 #F7F777 #F7F777 #F7F777 #F7F777 lime #ff6600 #F7F777 #F7F777 #F7F777 #F7F777 #F7F777 #F7F777
SQL Category SQL Count Plan Change Count
Overall 0 0
Common 0 0
Improved
Regressed
Unchanged
with Timeout
 0
with Errors
 0
Unsupported
 0
Unknown
Improved
Regressed
Unchanged
with Timeout 0
with Errors 0
Unsupported 0
Unknown
Different 0 0
Missing SQL
 0
New SQL

Projected Workload Performance Distribution

Single SQL Statement Execution Count Distribution

Bucket		 Cumulative Perf.
Before Change
(%)		 Cumulative Perf.
After Change
(%)
< = % %


Bucket		 SQL Count
Before Change
(%)		 SQL Count
After Change
(%)
< = % %

Top SQL Sorted by
lime #ff6600

object_id
sql_id		 Impact on
Workload		 Execution
Frequency 		Total Metric
Before 		Total Metric
After 		Metric
Before		 Metric
After		 Impact
on SQL		 % Workload
Before		 % Workload
After		 Plan
Change
# % % % %
Note: time statistics are displayed in microseconds

Top SQL Sorted by

object_id
sql_id
Executions		 Parse
time(s)		 Elapsed
time(s)		 CPU
time(s)		 Buffer
gets
# xxx xxx xxx xxx

Top SQL Sorted by
object_id sql_id Executions Optimizer cost Parse time(s)
# xxx xxx

Top SQL Sorted by (Cumulative Statistics)
object_id sql_id Execs. Elapsed Time(s) CPU Time(s) Buffer Gets Plans
# xxx xxx xxx

Top Errors (Grouped by Error Code) Sorted by SQL Count
Error Code SQL Count Error Message (sample)

Top SQL with Error Sorted by object_id
object_id sql_id Error Message
#

Top Unsupported SQL Statements Sorted by object_id
object_id sql_id sql_text
#

Top SQL Statements with Timeout Sorted by object_id
object_id sql_id Message
#


Bind Variables:
- ():

SQL Details:
Object ID :
Schema Name :
SQL ID :
Execution Frequency :
SQL Text :

Errors:

SQL Execution Statistics (average):
Execution Statistics:

Stat Name		 Impact on
Workload		 Value
Before		 Value
After		 Impact
on SQL		 % Workload
Before		 % Workload
After
% % % %
Note: time statistics are displayed in seconds

Execution Statistics:
: xxx
:
Note: time statistics are displayed in seconds

SQL Execution Statistics (average):
: xxx
:
Note: time statistics are displayed in seconds

Findings ():


Plan Execution Statistics (average):
Statistic Name Plans Before Change Plans After Change
plan hash value
schema name

Execution Plans Before Change:

Execution Plans After Change:

Execution Plan Before Change:

Execution Plan After Change:

Execution Plan:

Plan Execution Statistics (average):
Name Value
plan hash value
schema name

Execution Plans ():

Notes:


Notes:
Before Change:

After Change: