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

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-l
Received on Tue Jul 24 2012 - 10:58:00 CDT

Original text of this message