SQL Set Compare Report Does Not Match SQLs (Doc ID 2191933.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

 

Top 100 SQL Sorted by Absolute Value of Change Impact on the Workload

object_id sql_id Impact on Workload Total Metric Before Total Metric After Impact on SQL Plan Change

22606 csgtkcwvs30vy       -17.24%         210823641        n
22607 csgtkcwvs30vy        14.01%         171319196        n
2385 1c2mnd18jj337        -13.75%         168144500        n
2384 1c2mnd18jj337         11.05%         135177784        n
3382 1xtw54y9n5vds          7.96%         97310962         n
3381 1xtw54y9n5vds         -6.76%         82703139         n


Pre-Trail - 12.1.0.2 With Jan2016 PSU
Post-Trail - 12.1.0.2 With Apr2016 PSU

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms