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 08:58:00 -0700
Message-ID: <CAGXkmivUvKBv8WKnAv4Am4XpdUANfWV3mrL_b_99Etauk-WQRQ_at_mail.gmail.com>
I'm nearly 100% sure that dbms_sqldiag is not part of any management pack license (do note you mentioned dbms_sqltune which is not required for TCB export).
See there is no mention of it here:
http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#autoId30 http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#autoId35
Date: Tue, 24 Jul 2012 08:58:00 -0700
Message-ID: <CAGXkmivUvKBv8WKnAv4Am4XpdUANfWV3mrL_b_99Etauk-WQRQ_at_mail.gmail.com>
I'm nearly 100% sure that dbms_sqldiag is not part of any management pack license (do note you mentioned dbms_sqltune which is not required for TCB export).
See there is no mention of it here:
http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#autoId30 http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#autoId35
I think your best bet is to be able to package the issue so Oracle Support can reproduce it.
On Tue, Jul 24, 2012 at 4:26 AM, Thomas Kellerer <thomas.kellerer_at_mgm-tp.com
> wrote:
> Hi Greg,
>
> thanks. Will do that but it will take a while because we don't have direct
> access to production.
> (And the tuning/diagnostic packs are not licensed on either machine, so I
> cannot use dbms_sqltune)
>
>
-- 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 - 10:58:00 CDT