Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 24 Jul 2012 19:59:30 -0700
Message-ID: <CAGXkmiuMbNF61qDE2nJC+N-WSB1O_vocdkmvx6y4TahYOtYUPw_at_mail.gmail.com>
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.
Date: Tue, 24 Jul 2012 19:59:30 -0700
Message-ID: <CAGXkmiuMbNF61qDE2nJC+N-WSB1O_vocdkmvx6y4TahYOtYUPw_at_mail.gmail.com>
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_at_rsiz.com> 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-lReceived on Tue Jul 24 2012 - 21:59:30 CDT