Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: "Mark W. Farnham" <mwf@xxxxxxxx>
- Date: Tue, 24 Jul 2012 19:59:30 -0700
TCB was designed to extract the required objects and stats from production environments to recreated them in test environments for plan debugging. So I would say that Niall's "issue" falls outside the scope of design, though noteworthy. On Tue, Jul 24, 2012 at 2:37 PM, Mark W. Farnham <mwf@xxxxxxxx> wrote: > Test case builder is not intended to be used on the production database, is > it? (If it is, I think that is a security bug, a change management bug, and > in general dangerous.) > > Now especially given your find and example, I *hope* it comes in future > with > a stronger warning about either not running it on production or running it > very carefully on production. > > mwf > > -- Regards, Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> | linkedin <http://linkd.in/gregrahn> -- http://www.freelists.org/webpage/oracle-l
- References:
- Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Thomas Kellerer
- Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Greg Rahn
- Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Thomas Kellerer
- Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Greg Rahn
- Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Niall Litchfield
- RE: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
- From: Mark W. Farnham
- Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
Other related posts:
- » Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Greg Rahn
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Carlos Sierra
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Greg Rahn
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Niall Litchfield
- » RE: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Mark W. Farnham
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Greg Rahn
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Nuno Souto
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Martin Bach
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Nuno Souto
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - fairlie rego
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Nuno Souto
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - De DBA
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - fairlie rego
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Carlos Sierra
- » Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2 - Thomas Kellerer