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 18:26:51 -0700 (PDT)
Message-ID: <1343266011.65152.YahooMailNeo_at_web45001.mail.sp1.yahoo.com>

Hi Tony,
Got the bug details from Nuno

They are 

Patch#14215851 and this is the name of the file it comes in: p14215851_112031_Generic.zip  
It's a generic PL/SQL dictionary
patch so it can be applied without shutting the db down – no relink: it replaces a couple of files in $ORACLE_HOME/rdbms/admin and then there is a series of scripts that must be run in sequence from the same directory.

This is not the same as below

 
From my skimming through it ... it appears to only impact exports on 11.2.0.3. So might not be relevant to you

Ta
Fairlie

 

---

 From: De DBA <dedba_at_tpg.com.au>
To: fairlie_r_at_yahoo.com
Cc: "dbvision_at_iinet.net.au" <dbvision_at_iinet.net.au>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, 26 July 2012 10:00 AM
Subject: Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2  

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

Received on Wed Jul 25 2012 - 20:26:51 CDT