Re: Oracle license requirements for unused options

From: De DBA <>
Date: Thu, 27 Oct 2011 09:09:40 +1000
Message-ID: <>

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:
> 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:
> tel +32(0)3 451 23 82
> disclaimer:
> -----Original Message-----
> From: [] On Behalf Of De DBA
> Sent: woensdag 26 oktober 2011 5:23
> To:
> Subject: Re: Oracle license requirements for unused options
> That is a bit of an eye-opener... I ran this statement on my play database ( 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

Received on Wed Oct 26 2011 - 18:09:40 CDT

Original text of this message