RE: Any concerns with the advisor privilege?

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) 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 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