RE: Any concerns with the advisor privilege?
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <pgr@xxxxxxxxxxxx>
- Date: Tue, 9 Apr 2013 13:02:29 -0500
Yeah that seems to be a bit misleading. It appears that Oracle is saying that
RAT gives you that ability, but it does not seem to be saying it is EXCLUSIVE
to RAT.
That section falls under the main Real Application Testing Heading and they've
already stated just above that that creating SQL Tuning sets are included in
both RAT and the Tuning pack so I believe it to be a misread to infer that RAT
is the only option here.
Regards,
Chris
From: Peter Gram Miracle A/S [mailto:pgr@xxxxxxxxxxxx]
Sent: Tuesday, April 09, 2013 12:57 PM
To: Taylor Christopher - Nashville
Cc: rjoralist2; oracle-l
Subject: Re: Any concerns with the advisor privilege?
Hi
Yes I have documentation it's stated in the manual Oracle(r) 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@xxxxxxxxxxxx<mailto:peter.gram@xxxxxxxxxxxx>
OakTable member<http://www.oaktable.net> <http://www.oaktable.com/>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
