Re: Any concerns with the advisor privilege?

From: Peter Gram Miracle A/S <pgr_at_miracleas.dk>
Date: Tue, 9 Apr 2013 19:56:31 +0200
Message-ID: <CAP=Qj19XjtQnhuCe1WVSWZ9ynbfWrPN3suSPNodjmFQA=kCY4g_at_mail.gmail.com>

Hi
Yes I have documentation it's stated in the manual Oracle® Database Licensing Information 11g Release 2
(11.2)<http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#CJAGBGHH>   :

 SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. The following subprograms, part of the DBMS_SQLTUNE package, provide an interface to manage SQL tuning sets and are part of the Oracle Real Application Testing option:

   -

   ADD_SQLSET_REFERENCE
   -

   CAPTURE_CURSOR_CACHE_SQLSET
   -

   CREATE_SQLSET
   -

   CREATE_STGTAB_SQLSET
   -

   DELETE_SQLSET
   -

   DROP_SQLSET
   -

   LOAD_SQLSET
   -

   PACK_STGTAB_SQLSET
   -

   REMOVE_SQLSET_REFERENCE
   -

   SELECT_CURSOR_CACHE
   -

   SELECT_SQLSET
   -

   SELECT_WORKLOAD_REPOSITORY
   -

   UNPACK_STGTAB_SQLSET
   -

   UPDATE_SQLSET /Gram

Best Regards / Venlig Hilsen

Peter Gram

Miracle Consulting <http://www.miracleas.dk> Borupvang 2c, 2750 Ballerup, Denmark
Cell: (+45) 53747107 Home: (+45) 38745696 Office Phone: (+45) 44668855 Office Fax: (+45) 44668856 Mail: peter.gram_at_miracleas.dk
OakTable member <http://www.oaktable.net> <http://www.oaktable.com/>

---

On 9 April 2013 19:24, <Christopher.Taylor2_at_parallon.net> wrote:

> Peter,
>
> Do you have a documentation link for that?
>
> From my reading of RAT, it appears that SQL Performance Analyzer (part of
> RAT) integrates with the ability to create SQL sets and only SPA requires a
> RAT license.
>
> Admittedly, I'm in the shallow end of the pool here, so any documentation
> you can provide on the matter would be appreciated!
>
> Chris
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Peter Gram Miracle A/S
> Sent: Tuesday, April 09, 2013 12:14 PM
> To: rjoralist2_at_society.servebeer.com
> Cc: oracle-l
> Subject: Re: Any concerns with the advisor privilege?
>
> Hi Rich
> You are right but if you use any of ties calles in the dbms_sqltune package
>
> -
>
> ADD_SQLSET_REFERENCE
> -
>
> CAPTURE_CURSOR_CACHE_SQLSET
> -
>
> CREATE_SQLSET
> -
>
> CREATE_STGTAB_SQLSET
> -
>
> DELETE_SQLSET
> -
>
> DROP_SQLSET
> -
>
> LOAD_SQLSET
> -
>
> PACK_STGTAB_SQLSET
> -
>
> REMOVE_SQLSET_REFERENCE
> -
>
> SELECT_CURSOR_CACHE
> -
>
> SELECT_SQLSET
> -
>
> SELECT_WORKLOAD_REPOSITORY
> -
>
> UNPACK_STGTAB_SQLSET
> -
>
> UPDATE_SQLSET
>
> you need the Oracle Real Application option.
>
>
>
>
> Best Regards / Venlig Hilsen
>
> Peter Gram
>
> Miracle Consulting <http://www.miracleas.dk> Borupvang 2c, 2750 Ballerup,
> Denmark
> Cell: (+45) 53747107 Home: (+45) 38745696 Office Phone: (+45) 44668855Office Fax: (+45)
> 44668856
> Mail: peter.gram_at_miracleas.dk
> OakTable member <http://www.oaktable.net> <http://www.oaktable.com/>
> ----------------------------------------------------
>
>
>
>
> On 9 April 2013 18:52, Rich Jesse <rjoralist2_at_society.servebeer.com>
> wrote:
>
> > Peter writes:
> >
> > > Just check that you have the purchased the Oracle Real Application
> > > Testing<
> > http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#CJA
> > GBGHH
> > >option
> > > before you
> > > give anybody access to that package.
> >
> > Keep reading further in the document:
> >
> > http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#aut
> > oId35
> >
> > It's apparently included in both licenses.
> >
> > Rich
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 09 2013 - 19:56:31 CEST