I work for an outsourcer and the question has been made from one of our customers. I agree that if I used something I should pay for it but obviously the decision is not mine . I looked at bug you show me but saw that it is for 10.2.0.x and I have ASO used on 11.2.0.2 . For diagnostic and tuning pack on 11 version I know there is CONTROL_MANAGEMENT_PACK_ACCESS and if you set it to NONE you disable all. For 10g I will open an SR becouse customer asks us something which i don't know and on which I don't find any suggestion . If after i open a SR Oracle corps goes to customer ...it is an our problem .. I have no other way . Thanks for all 2012/11/27 Patterson, Joel <Joel.Patterson@xxxxxxxxxxx> > 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