Re: Any concerns with the advisor privilege?

From: Peter Gram Miracle A/S <pgr_at_miracleas.dk>
Date: Tue, 9 Apr 2013 19:13:43 +0200
Message-ID: <CAP=Qj1_2m7P+j-mMFD=4j_a6PHcfPYZUyWgKTHwpOUbTz_Qk5w_at_mail.gmail.com>

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#CJAGBGHH
> >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#autoId35
>
> It's apparently included in both licenses.
>
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Apr 09 2013 - 19:13:43 CEST