Re: Oracle license requirements for unused options
Date: Thu, 27 Oct 2011 09:09:40 +1000
I know about it, but it never occurred to me that it had to be touched on databases where I have neither a dbconsole, nor an enterprise manager agent - don't use the buggers anyway.
Tuning Pack is an add-on to OEM, right?
On 26/10/11 6:30 PM, D'Hooge Freek wrote:
> In 11g (not sure if was there in 11.1 or only in 11.2) there is a parameter control_file_management_pack_access. For enterprise editions this is standard set to 'DIAGNOSTIC+TUNING', which enables all these automatic tasks.
> You have to set this to 'NONE' when you don't have the tuning or diagnostic pack.
> Nice trick of Oracle to enable it by default...
> Freek D'Hooge
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> disclaimer: www.uptime.be/disclaimer
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of De DBA
> Sent: woensdag 26 oktober 2011 5:23
> To: oracle-l_at_freelists.org
> Subject: Re: Oracle license requirements for unused options
> That is a bit of an eye-opener... I ran this statement on my play database (188.8.131.52) where I am quite sure that I never used the tuning pack, but it shows that it was last used only a few days back... Turns out this is because of the Automatic SQL Tuning Advisor, which as far as I can ascertain is enabled by default? I surely never ran DBMS_AUTO_TASK_ADMIN.ENABLE(..)... Yet another point to remember to disable when creating a new database... :(
> Makes one wonder what more extra licensable features are enabled by default...