Oracle 10g charges extra for 10g automation features

Oracle Tips by Burleson Consulting
February 17, 2004

In a stunning turn of events, Oracle has announced that their much-publicized Oracle10g built-in automation features will be extra cost options. Even though Oracle invested millions of dollars to make the self-tuning features built-in to the Oracle kernel, Oracle is now restricting those views and packages that you can execute from the core Oracle 10g software.

This means that the Oracle10g DBA must be very careful not to accidentally invoke an extra-cost package within the basic Oracle10g install. According to Kyle Hailey of Oracle Corporation, the AWR, ADDM, ASH & SQL Tuning Advisor are extra-cost options within Oracle10g.

The extra-cost Database Diagnostic Pack covers access to:

AWR - Automatic Workload Repository

dbms_workload_repository package

awrrpt.sql and awrrpti.sql reports

dba_hist_* and v$active_session_history views

ADDM - Automatic Database Diagnostic Monitor

All dbms_advisor package with "ADDM" as the value to the "advisor_name" parameter

The addmrpt.sql, addmrpti.sql reports

Views starting with dba_advisor_* of all tasks generated by ADDM (i.e. tasks with "ADDM" as the "advisor_name" column in dba_advisor_tasks view)

The extra-cost Database Tuning Pack is required to access SQL Tuning Advisor PL/SQL Packages located in $ORACLE_HOME/rdbms/admin.

dbms_advisor package with "SQL Tuning Advisor" as the
value to the "advisor_name" parameter.
dbms_sqltune package

If you like Oracle tuning, see my latest book "Oracle Tuning: The Definitive Reference".

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts:

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

��