Amen! Yeah, this licensing agreement has been pretty controversial since the beginning, and I know at least one Oracle insider who lobbied hard to make at least the active session history included in the database license....but apparently to no avail.... -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning "Exception: Some dividends may be reported as qualified dividends but are not qualified dividends. These include: * Dividends you received on any share of stock that you held for less than 61 days during the 121-day period that began 60 days before the ex-dividend date. The ex-dividend date is the first date following the declaration of a dividend on which the purchaser of a stock is not entitled to receive the next dividend payment. When counting the number of days you held the stock, include the day you disposed of the stock but not the day you acquired it. See the examples below. Also, when counting the number of days you held the stock, you cannot count certain days during which your risk of loss was diminished. See Pub. 550 for more details." --IRS, Form 1040-A Instruction Booklet, Line 9b: Qualified Dividends ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon Sent: Wednesday, March 01, 2006 3:35 PM To: Kelley.Coleman@xxxxxx; MATT.ADAMS@xxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: diagnostics pack - 10g licensing I just found the following in the 10.2 documentation on licensing for the Diagnostics Pack (http://download-west.oracle.com/docs/cd/B19306_01/license.102/b14199/op tions.htm#CIHHIGBI): 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.