Oracle Charges Extra for Repository Diagnostic Features
June 9, 2004
Oracle10g Automated Session History
views will be an extra-cost option, according to sources at Oracle.
Oracle 10g has the
DBA_HIGH_WATER_MARK_STATISTICS views to tell if you have been
using specific Oracle features.
Tony Jambu, noted Oracle expert and
author, just published this interesting tidbit about Oracle
"It was probably too good to be true that users of Oracle
RDBMS would have all these Automatic features for free. If
you are about to purchase or use Oracle 10g, you need to be
aware of the following information which was brought to my
attention by Don Burleson, CEO of Burleson Consulting:
If you are going to be using or testing Oracle's Active
Session History (ASH), Automatic Workload Repository (AWR),
Automatic Database Diagnostic Monitor (ADDM) or SQL Advisor, you
will need to acquire additional licenses. In February 2004,
Kyle Hailey, Principal Member of Technical Staff, Oracle
Corporation announced that the automatic options would require
additional Oracle option licenses.
Richard Stroupe (firstname.lastname@example.org)
pointed me to the Oracle documentation on
Oracle Management Packs
The sections that follow
describe the Oracle management packs. The management packs can
be purchased only with Enterprise Edition. The features in these
packs are accessible through Oracle Enterprise Manager Database
Control, Oracle Enterprise Manager Grid Control, and APIs
provided with Oracle Database software.
So what is the issue? From the documentation, Oracle has
bundled the AWR and ADDM into the Oracle Diagnostic Pack and ASH
and SQL Advisor into the Tuning Pack. This was always the plan
but was not announced at any of the presentations or press
What this means is that customers that do not already have these
optional packs will need to pay US$3000 per CPU per Enterprise
Manager option pack. This is another 15% on top of the based
RDBMS price if you use the ASH, AWR, ADDM and SQL Advisor
functionality. Be aware that these option packs are not offered
with the Standard Edition or Standard Edition One RDBMS.
So you think that you are doing the right thing by not using
these products and will not require these optional packs right?
In reality, you may be using them without knowing it.
The underlying objects, programs and views are created by
default in 10g. If you access any of the following views:
ˇ The V$ACTIVE_SESSION_HISTORY dynamic performance view
ˇ All data dictionary views beginning with the prefix
DBA_HIST_* along with their underlying tables.
and others mentioned in the link above, you are required to
purchase the optional EM packs. You will be doing yourself a
favor by reading the above link on licensing which is OracleŽ
Database Licensing Information 10g Release 1 (10.1) Part Number
As an aside, if you are considering purchasing Oracle Standard
Edition One, the following information might be of interest to
Named User Plus Per Processor
RDBMS Standard Edition One$149$4,995
RDBMS Standard Edition$300$15,000
RDBMS Enterprise Edition$800$40,000
If we use Oracle's ratio of number of Named User Plus to full
Per Processor license, we get 50:1 for SE and EE licenses but
only 33.5:1 for SE One. Or looking at it from another view, the
Named User Plus SE One ratio to SE is 1:2 but their Per
Processor ratio is 1:3. The SE One Per Processor license should
have been $7,450 but is discounted to $4,995. Oracle took this
step to be competitive against Microsoft's SQ Server."