RE: Any concerns with the advisor privilege?
Date: Tue, 9 Apr 2013 13:02:29 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879BD1CD04_at_NADCWPMSGCMS10.hca.corpad.net>
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_at_miracleas.dk]
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
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<mailto:peter.gram_at_miracleas.dk>
OakTable member<http://www.oaktable.net> <http://www.oaktable.com/>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 09 2013 - 20:02:29 CEST