RE: Any concerns with the advisor privilege?
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <pgr@xxxxxxxxxxxx>, <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 9 Apr 2013 12:24:18 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Peter Gram Miracle A/S
Sent: Tuesday, April 09, 2013 12:14 PM
To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxx
OakTable member <http://www.oaktable.net> <http://www.oaktable.com/>
----------------------------------------------------
On 9 April 2013 18:52, Rich Jesse <rjoralist2@xxxxxxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
