My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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



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 - With Jan2016 PSU
Post-Trail - With Apr2016 PSU



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.