SQL Developer 19.4.
I have a single, somewhat complex query that performs wildly differently in two different Oracle instances. Stats are up-to-date in each; volumes are also the same between databases. I am naturally trying to identify the source of the difference, trying to find the characteristic in the "fast" database, which I'm assuming I can apply to the "slow" one.
The difference in plans is considerable.
I was going to compare autotraces between the two databases, but to me it is looking like that utility in SQL Developer only compares two (different) queries' autotraces in the same database. Is that correct? If not, how can I use SQL Developer's autotrace compare across databases?
Failing that, I may have to comb through 10053 traces for each database to see if something jumps out at me.
Thanks.