RE: Oracle license requirements for unused options

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 - 03:30:57 CDT