RE: Oracle license requirements for unused options

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "dedba@xxxxxxxxxx" <dedba@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Oct 2011 10:30:57 +0200

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