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

I am currently in the process of migrating a 4TB database from 9.2.0.8 
(HPUX) to 11.2.0.3 (Solaris 11) with TTS. We downloaded the 11.2.0.3 
software from oracle.com, which had the Jan PSU already included.

I noted only one bug during our first test run: ORA-600 [ktbesc_plugged]. That one is purportedly fixed in the April PSU. We've now applied the July PSU (which was released last week) and are currently in the middle of copying the db over again (takes 2.5 days for us - I'm glad it's not 18TB ;) )

Nuno, if this is not the bug that you are talking about, I'd be very glad if you could share the details :)

Cheers,
Tony

On 25/07/12 9:24 PM, fairlie rego wrote:
> 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.
>
>

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