Re: 10g Enthusiasm (Was: So what if 8i is outta support ?)

If you select from v$active_session_history for example, or use some of the performance related views and packages then you are liable for the cost of the diagnostics pack (on the same basis that your database is licensed - per processor or per end user).

>From the licensing information.

<quote>
Some Diagnostics Pack features are 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.

</quote>
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Fri Oct 29 2004 - 08:07:58 CDT