Thomas, If you have an SR, just upload to that SR and send me SR number. Thx -- Carlos On Fri, Jul 27, 2012 at 10:04 AM, Thomas Kellerer < thomas.kellerer@xxxxxxxxxx> wrote: > 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 11.2.0.2 and 11.2.0.3 which affects your plan so >> badly. >> >> > I have extracted two SQLT (XTRACT) reports now. > One with OFE = 11.2.0.2 and one with OFE = 11.2.0.3 > > The both show the differences in the plans. > > The zip files are both well over 100MB each. How can I let you have those > files? > > They do contain some sensible (customer's) information, so I can't really > put them somewhere "public". > > > Regards > Thomas > > > > > -- Cheers -- Carlos Sierra http://carlos-sierra.net/ -- //www.freelists.org/webpage/oracle-l