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 -- //www.freelists.org/webpage/oracle-l