Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: De DBA <dedba@xxxxxxxxxx>
- To: fairlie_r@xxxxxxxxx
- Date: Thu, 26 Jul 2012 10:00:34 +1000
Hi Fairlie,
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@xxxxxxxxxxxx>
> To: oracle-l@xxxxxxxxxxxxx
> 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.
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
