Re: Oracle license requirements for unused options

From: De DBA <dedba_at_tpg.com.au>
Date: Thu, 27 Oct 2011 09:09:40 +1000
Message-ID: <4EA89334.6030503_at_tpg.com.au>

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_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> 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 (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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

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