Re: question on option pack .
- From: De DBA <dedba@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Nov 2012 16:25:20 +1000
My 2 cents:
On point 1, AFAIK no parameter setting will disable the dictionary views
that form part of licensable options. You are just required to exercise
restraint.. I believe that SQL Profiles can be created manually and are
not part of the D&T packs, but I might be wrong there. All "ADVISOR"
jobs are licensed, so they should be disabled (even though they are
enabled by default), but statistics gathering is required for normal
operation and included in the base package.
On point 2, You may be hit by bug 5475037 "Feature usage statistics
incorrectly show 'Advanced Security' to be used." In that case, there
would not be anything you could do about it.
In most cases you cannot disable anything - you're just expected not to
use features that are installed by default and readily available to any
user with the correct system privileges. In many cases the
dba_feature_usage_statistics view shows 2 components to a feature, one
marked with "(system)" and the other with "(user)". As far as I know,
the first one is not licensable as it reflects usage by oracle
background processes. The latter is "actual" usage and must be covered
by a license.
Perhaps Mogens Norgaard can shatter some light on it... ? ;)
Cheers,
Tony
On 28/11/12 6:00 AM, Patterson, Joel wrote:
> I'll take a stab at #1 --
>
> 1a) Can you not go to 'setup' on your OEM home page at the top right, then
> select Management pack Access, and then uncheck any database you do not wish
> to be licensed for...
>
> 1b) How about for example:
> exec sys.dbms_scheduler.disable( '"SYS"."AUTO_SPACE_ADVISOR_JOB"' )
>
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of pier paolo Bruno
> Sent: Monday, November 26, 2012 6:01 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: question on option pack .
>
> A customer asked me 2 questions and i am not sure of the answer so i'd ask
> your experience
> 1) they have some instances and they want to disable diagnostic and tuning
> pack . Istances are 10.2.0.3 and so there is not init parameter.
> On metalink i found that i can disable awr collection or addm but i don't
> think it is sufficient, example, if there are sql profile i imagine I have to
> drop it.
> How can i disable tuning and diagnostic pack and be sure Oracle can not ask
> me money ? Have I to disable all management jobs (segment advisor and so
> on) ? standard statistic job on 10g too ? I was not able to find answer on
> support on what is to disable (they used tuning and diagnostic pack for years
> and only now they feel the problem)
>
> 2) They have some instances (11.2.0.2) on which the query on support which
> tell you what features you are using (based on DBA_FEATURE_USAGE_STATISTICS
> )
> warns that they are using advanced security. Their development told them that
> they don't use it and customer asks us to disable Advanced security .
> I did not find any note that explain how to disable it on 11g . they want to
> disable it in any case, even if it is used in some place becouse they don't
> want to pay for it and prefer to loose the funcionality
>
> I am even not sure if it is possible to do what they ask us, exspecially for
> 2nd question .
> Thanks in advance
> Pier Paolo
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
