Re: Completely insane execution plan with but not with

  • From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Jul 2012 10:42:17 +0200

Carlos Sierra, 24.07.2012 13:12:
> You may want to install SQLT (215187.1) in both environments and use
> XTRACT method. Then send me output for diagnostics. I would use SQLT
> XPLORE in your SQLT, which basically helps to narrow the optimizer
> change between and which affects your plan so
> badly.

Thanks for the offer.

I cannot install SQLT in production, but I can run the statements in our test 
environment once with OFE enabled and once with OFE enabled 
if that would be enough.


Other related posts: