SQL Plan Diff Report .
Plan Id :
Plan Hash Value : :

Id Operation Name

Predicate Information (identified by operation id):
  • - ()

Note
- dynamic sampling used for this statement - SQL profile used for this statement - SQL plan baseline used for this statement - SQL patch used for this statement
*   # General Information

Task Information:
Workload Information:
Task Name :
Task Owner :
Description :
Execution Name :
Execution Type : REMOTE
Database Link :
Description :
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 :

Report Details:
SQL Plan Comparison

Errors:

Query Block Diff

Query Block SQL Plan 1 SQL Plan 2 Diff
red white red white red white red white #

Item Type SQL Plan #1 SQL Plan #2
white yellow black white white yellow black white
white yellow black white white yellow black white

Bug# Fix Description SQL Plan #1 SQL Plan #2
white yellow black white white yellow black white

Join Order Diff

Query Block SQL Plan 1 SQL Plan 2
red white # red white red white

Join Method Diff

Query Block Table to Join SQL Plan 1 SQL Plan 2
red white # red white red white red white

Diff Transformation SQL Plan 1 SQL Plan 2 Query block
red white red white red white red white red white