Re: Oracle license requirements for unused options

  • From: De DBA <dedba@xxxxxxxxxx>
  • To: "D'Hooge Freek" <Freek.DHooge@xxxxxxxxx>
  • 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?

Cheers,
Tony

On 26/10/11 6:30 PM, D'Hooge Freek wrote:
> Tony,
>
> 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
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
> Behalf Of De DBA
> Sent: woensdag 26 oktober 2011 5:23
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Oracle license requirements for unused options
>
> That is a bit of an eye-opener... I ran this statement on my play database 
> (11.2.0.1) 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...
>
> Cheers,
> Tony
>
>
>
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2011