Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Wed, 25 Jul 2012 04:24:06 -0700 (PDT)
Message-ID: <1343215446.85902.YahooMailNeo_at_web45016.mail.sp1.yahoo.com>

Hi Nuno,
I am in the process of planning a TTS migration of a 18TB database to 11.2.0.3 So I am interested in every problem related to transportable tablespaces.

The source DB is on 10.2.0.3 + 50 patches (none of these are cpus) but highly susceptible to bugs since a lot of exotic functionality is used :-)

If you have the details I would love to know them

Ta

 
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 403 607 698

 

---

 From: Nuno Souto <dbvision_at_iinet.net.au> To: oracle-l_at_freelists.org
Sent: Wednesday, 25 July 2012 8:36 PM
Subject: Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2  

Thomas, I was getting a very similar problem with a vanilla 11.2.0.3 install on Aix7.1.  Then I installed the May 2012 PSU and the problem went away. There are quite a few optimizer-related patches in that PSU.

One thing though: the MayPSU includes the Jan012 CPU which created a problem for transportable tablespaces.  That is fixed by applying another patch on top of the May PSU. MOS has the number and I can get it to you if interested.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au



Thomas Kellerer wrote,on my timestamp of 24/07/2012 9:26 PM:



> As large parts of the plan are moved around due to the different order of execution, it's hard to

> spot the differences in a diff  output (even a visual one).

>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 25 2012 - 06:24:06 CDT