Donald Burleson Click here for more Oracle News Headlines

Oracle 10g charges extra for 10g automation features

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
   

---

Is your RAC database Healthy? Get the experts at Burleson Consulting to conduct a two day RAC health check and ensure the health of your RAC database.  Why guess?  Have your RAC database certified by experienced RAC experts.