RE: diagnostics pack - 10g licensing

  • From: "Adams, Matthew (GE Indust, ConsInd)" <MATT.ADAMS@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Mar 2006 09:15:27 -0500

I've got the licenses.  I just need the software to use with the 10.2 OEM java 
Anybody know where it is?

-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx]
Sent: Wednesday, March 01, 2006 3:35 PM
To: Kelley.Coleman@xxxxxx; Adams, Matthew (GE Indust, ConsInd); 
Subject: RE: diagnostics pack - 10g licensing

I just found the following in the 10.2 documentation on licensing for the 
Diagnostics Pack (

Oracle Diagnostic Pack

The Oracle Diagnostic Pack provides automatic performance diagnostic and 
advanced system monitoring functionality. The Diagnostic Pack includes the 
following features:

<blah, blah, blah>

In order to use the features listed above, you must purchase licenses for the 
Diagnostic Pack. The Diagnostics Pack functionality can be accessed by 
Enterprise Manager links as well as through the database server command-line 
APIs. The use of either interface requires a Diagnostic Pack license.

Command-Line APIs

Diagnostics Pack features can also be accessed by way of database server APIs 
and command-line interfaces:

The DBMS_WORKLOAD_REPOSITORY package is part of this pack.

The DBMS_ADVISOR package is part of this pack if you specify ADDM as the value 
of the advisor_name parameter, or if you specify for the value of the task_name 
parameter any value starting with the ADDM prefix.

The V$ACTIVE_SESSION_HISTORY dynamic performance view is part of this pack.

All data dictionary views beginning with the prefix DBA_HIST_ are part of this 
pack, along with their underlying tables.

All data dictionary views with the prefix DBA_ADVISOR_ are part of this pack if 
queries to these views return rows with the value ADDM in the ADVISOR_NAME 
column or a value of ADDM* in the TASK_NAME column or the corresponding TASK_ID.

The following reports found in the /rdbms/admin/ directory of the Oracle home 
directory are part of this pack: awrrpt.sql, awrrpti.sql, addmrtp.sql, 
addmrpti.sql, awrrpt.sql, awrrpti.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, 
ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql.

Am I the only one that thinks this is ridiculous?  Why does Oracle include all 
this functionality and then tell you that you can't use it unless you have a 
separate license?  I guess it's just a sleezy sales tactic, just like a car 
salesman letting you test drive a car that he knows costs more than you said 
you want to spend, but how can they expect us to know which views, scripts, 
procedures, etc. are off-limits?  It's one thing to be using OEM and know that 
you can't click on anything in the Diagnostics Pack menu, but knowing all the 
different objects in the database that you can't use and keeping up with them 
all from version to version and release to release is impossible.  Can I get an 
amen brothers & sisters?!?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Coleman, Kelley (HAC)
Sent: Wednesday, March 01, 2006 1:18 PM
To: MATT.ADAMS@xxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: diagnostics pack

I understand that the Diagnostic Pack is a separately licensed product.
It should be available on OTN.

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.

Other related posts: