Oracle Tuning and Diagnostic Packs - Licensing

Posted on 2014-09-05
Last Modified: 2014-09-17

I'm after advice on the Oracle Tuning and Diagnostic Packs and what experiences people have used when it comes to licensing.

1. How many times can these packs be used for test/setup purposes before they need to be licensed?

2. When Oracle is installed, these packs get installed by default.  There are no instructions on how to switch these packs off.  Would anybody agree that Oracle by default have setup their installations to be non-compliant and will then charge the customer for this use!

3. When Oracle Enterprise Manager is installed and used, by default the database screen displays the "performance" and "SQL Monitor - Last Hour" screens which are part of the tuning and diagnostic packs, thus triggering non-compliance.

4. After the initial install of Oracle, no further warnings about having to license the tuning and diagnostic packs are displayed.  This is especially so when Databases are cloned/setup.  Given my experiences with Oracle Rdb or MIcrosoft SQL Server you pay for what you get.  There are no other features which are installed by default and then have to be licensed.  Oracle's procedure is counter-intuitive.

6.  Are there any other mitigating factors I can use in my discussions with Oracle?


Question by:TimGreeley
  • 3
  • 2
  • 2
LVL 37

Expert Comment

by:Geert Gruwez
ID: 40305707
yeah ... you forgot support ... or was  that topic 5 ?
when you have a problem they ask for awr or addm reports which also require those licenses
support people are oblivious to your licenses

by default the tuning and diagnostic pack are activated but you can disable them from init.ora file
restart is required

for test... if you have a small developer community... go for named user plus licenses
(or if your production environment has a very limited number of users)
LVL 76

Accepted Solution

slightwv (䄆 Netminder) earned 250 total points
ID: 40306383
1:  Oracle is pretty gracious on licensing for development, evaluation and educational purposes
Here is the 'fine print':
Oracle Technology Network Developer License Terms

2: answered above but failed to provide the specifics.  Here they are:
Beginning with Oracle Database 11g, the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter controls access to the Diagnostic Pack and Tuning Pack. You can set this parameter to one of the following values:

•DIAGNOSTIC+TUNING — Diagnostic Pack and Tuning Pack functionally is enabled in the database server.
•DIAGNOSTIC — Only Diagnostic Pack functionality is enabled in the server.
•NONE — Diagnostic Pack and Tuning Pack functionally is disabled in the database server.

3: Don't see a question here but the 'links' are talked about in the doc link above

4: Oracle is more trusting.  Thus no license keys, etc...  when installing.  Using the liberal test/education license posted above I believe the thought is:
If we give folks free access to develop products, we'll get additional purchases from people using those products.

There are quite a few internal tables/views that track 'usage' of features and options.  Some of these are published.  I would be afraid of the ones that weren't published...

They likely also have a great batch of Lawyers if they ever catch you running unlicensed in production.

6:  Discussions about what?
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
ID: 40306439
free access to 1 person for 30 days for testing and development
after it should be licensed
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.


Author Comment

ID: 40318774
Thanks for all your updates.  

Oracle are saying that I have used the Tuning and Diagnostics packs.

My argument is that these options are installed by default.  No instructions in the install are provided by Oracle on how to switch these options off.  When you use Oracle Enterprise Manager in default mode this will automatically use the diagnostic and tuning options.  By default Oracle have set up our installations to be non-compliant and now want to charge me for this!
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40319153
I know this is a bad analogy but here it goes:
You buy a car and by default it has a top speed on 100 MPH.  Try making your argument to the cop that since the car allows you to go 100, you should be able to.

I understand your argument that if they didn't want you to use it, it should be disabled but look at it from an Oracle Marketing perspective:  Once you see how valuable it is, you might be more likely to purchase it.

I'm not a lawyer and do not work for Oracle so this is just one DBAs opinion:
I don't think Oracle will arrest you if they audit your systems and see you have 'accidentally' used it once or twice.

Author Comment

ID: 40328624
Still a lot of money to tru up the license usage....
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40328648
Yes it is.

Many years ago when Oracle first started adding the 'Advisors' to Enterprise Manager I was in the tuning class and the instructor made the claim:
Oracle ran a test:
Running the OEM Advisors versus a week of a group of Oracle Consulting.
The end result was the same performance gains.

I commented:
The OEM performance pack was about the same cost of the week of Oracle Consulting.

It made the Instructor and class laugh!

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now