RE: Oracle license requirements for unused options

From: D'Hooge Freek <>
Date: Wed, 26 Oct 2011 10:30:57 +0200
Message-ID: <>


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
Oracle Database Administrator
tel +32(0)3 451 23 82

-----Original Message-----

From: [] On Behalf Of De DBA Sent: woensdag 26 oktober 2011 5:23
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...


-- Received on Wed Oct 26 2011 - 03:30:57 CDT

Original text of this message