RE: Oracle license requirements for unused options

From: <>
Date: Tue, 18 Oct 2011 14:16:05 +0000
Message-ID: <>

Revisiting this thread from back in May... Does anyone know of a method in 10g to check whether a Diagnostic Pack option was ever used? I'm concerned that someone might at some point have run an awrrpt on a dev database without realizing that required a license and want to check whether it has ever happened.

For 11g Oracle provides scripts to check this (option_usages.sql) but they don't seem to work in 10g.

Appreciate any help in advance.

BTW - people might find this of interest: I have verified that when we uninstall certain options and then patch the database the options come back.

Jay Miller

From: [] On Behalf Of Sent: Thursday, May 19, 2011 3:53 PM
Subject: RE: Oracle license requirements for unused options

Also, even if you didn't install an option as a base install applying the patch will install some options automatically.

The impression I'm getting is that whether Oracle charges for installed and unused options depends on whether you're on good terms with them or not.

Jay Miller
Sr. Oracle Database Administrator
From: [] Sent: Thursday, May 19, 2011 9:46 AM
To:;; Miller, Jay; Subject: RE: Oracle license requirements for unused options

I think Brandon has a point. The management packs are all installed, and you must constantly go in and 'uncheck' them in EM. Oracle will install everything by default unless you can stop it, and for example 'partitioning' is used by EM, whether you use it or not.

So Spatial Data, or partitioning, OLAP, RAT, Data Mining... seem to go in easily enough, but have you tried to remove them (which includes checking that you are doing it correctly)?

Having said that, I removed OLAP which I believe was all I needed to have everything removed for 11g. But 10g can still display options from previous DBA as shown by Sqlplus when logging in, (so 'upgrading' would keep them).


Joel Patterson
Database Administrator
904 727-2546

From: [] On Behalf Of Allen, Brandon Sent: Wednesday, May 18, 2011 1:47 PM
To: Dunbar, Norman (Capgemini);; Subject: RE: Oracle license requirements for unused options

I'm still not convinced that a license is required for unused options. I think there is a key distinction between the documentation that mentions licensing based on usage and those that mention licensing based on installation. My interpretation is as follows:

  • installation-based licensing - only pertains to the main database server software, e.g. "Oracle Database SE/EE" must be licensed for all processors on the host where it is installed
  • usage-based licensing - only pertains to specific pieces of add-on functionality such as the extra options (e.g. Partitioning) and management packs (e.g. Diagnostics Pack).

I'm not positive if that's correct, so don't take my word for it, but everything I've read so far seems to be pretty consistent on those two points.



-----Original Message-----
From: Dunbar, Norman (Capgemini) []

I'm in total agreement with you regarding the wording of the vast

majority of Oracle docs


Hopefully though, the above should show that "installed and/or run" as

frequently quoted by Oracle in their documents, means installing an

option or feature does require a license.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
Received on Tue Oct 18 2011 - 09:16:05 CDT

Original text of this message