AWR/ADDM/ASH charge your money!


如果不是今天看到Fenng的给 Larry Ellison 的公开信,事关 AWR 与 ASH文章中提到Mark Brinsmead的这封公开信,我也不知道AWR/ADDM/ASH这样几乎完全内置在数据库中的功能也是需要额外收费的。

仔细查了一下Oracle® Database Licensing Information,果然如此,汗。

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.

即使作为Oracle的员工,恐怕我也得私下里支持一下这位DBA的提议。在公开信中回复的comment中包含“SIGNATORY”字样就表示电子签名了。 🙂

如果说awrrpt.sql这样的脚本在不购买Oracle Diagnostic Pack的license情况下不允许使用,倒也还能控制,但是连内置在数据库里面的毫无限制的性能视图都不允许去查询,这样的license确实有些离奇,我想没有人能控制住自己不敲下select …. from V$ACTIVE_SESSION_HISTORY吧。

3 Comments Add yours

  1. 木匠 says:

    我是去年底知道的, 已经买了 ADDM 的 license.

  2. Thoams Zhang says:


Leave a Reply

Your email address will not be published. Required fields are marked *