Java 我如何知道 Oracle 诊断包和 Oracle 调优包是否随 Oracle 安装一起安装？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21024895/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How can I know if Oracle Diagnostics pack and the Oracle Tuning pack are installed with an Oracle installation?
提问by gravetii
As part of a project, I need to figure out if the oracle installation has the oracle diagnostics pack and the oracle tuning pack installed. Could anyone help me out as to how that can be done? Also, if present how can i disable them?
作为项目的一部分，我需要弄清楚 oracle 安装是否安装了 oracle 诊断包和 oracle 调整包。任何人都可以帮助我了解如何做到这一点？另外，如果存在，我该如何禁用它们？
I am using a windows machine.
我正在使用 Windows 机器。
Edit: From this documentI see that a new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS is to be set to NONE to disable the Oracle diagnostics pack and the Oracle tuning pack. Could anyone tell me where I need to set this parameter?
编辑：从该文档中，我看到一个新的初始化参数 CONTROL_MANAGEMENT_PACK_ACCESS 将设置为 NONE 以禁用 Oracle 诊断包和 Oracle 调整包。谁能告诉我需要在哪里设置这个参数？
Thanks
谢谢
采纳答案by Jon Heller
Query the initialization parameter control_management_pack_accessto determine if the Diagnostic and Tuning packs are enabled:
查询初始化参数control_management_pack_access以确定是否启用了诊断和调整包：
select * from v$parameter where name = 'control_management_pack_access';
The value can be changed like this:
该值可以像这样更改：
alter system set control_management_pack_access = none;
Possible values are NONE, DIAGNOSTIC, and DIAGNOSTIC+TUNING. The default is DIAGNOSTIC+TUNING.
可能的值为 NONE、DIAGNOSTIC 和 DIAGNOSTIC+TUNING。默认值为 DIAGNOSTIC+TUNING。
But those values do not mean you have licensed the product. And changing the value does not seem to disable the products.
但这些值并不意味着您已获得该产品的许可。更改值似乎不会禁用产品。
Instead of disabling, you can monitor them and ensure nobody is using them. Except it's difficult to know exactly which features are in each pack, and difficult to know if those features are used and who is using them and when. The view DBA_FEATURE_USAGE_STATISTICS may help. I've tried to pick the relevant features but I've certainly made mistakes:
您可以监视它们并确保没有人使用它们，而不是禁用它们。除了很难确切知道每个包中有哪些功能，并且很难知道是否使用了这些功能以及谁在使用它们以及何时使用。视图 DBA_FEATURE_USAGE_STATISTICS 可能会有所帮助。我试图选择相关的功能，但我肯定犯了错误：
select name, detected_usages, last_usage_date, last_sample_date
from dba_feature_usage_statistics
where name in (
'ADDM', 'Automatic SQL Tuning Advisor', 'Automatic Workload Repository',
'AWR Baseline', 'AWR Baseline Template', 'AWR Report', 'EM Performance Page',
'Real-Time SQL Monitoring', 'SQL Access Advisor',
'SQL Monitoring and Tuning pages', 'SQL Performance Analyzer',
'SQL Tuning Advisor', 'SQL Tuning Set (system)', 'SQL Tuning Set (user)'
)
order by name;
NAME DETECTED_USAGES LAST_USAG LAST_SAMP
------------------------------- --------------- --------- ---------
ADDM 0 05-JAN-14
AWR Baseline 0 05-JAN-14
AWR Baseline Template 0 05-JAN-14
AWR Report 0 05-JAN-14
Automatic SQL Tuning Advisor 24 05-JAN-14 05-JAN-14
Automatic Workload Repository 0 05-JAN-14
EM Performance Page 0 05-JAN-14
Real-Time SQL Monitoring 24 05-JAN-14 05-JAN-14
SQL Access Advisor 0 05-JAN-14
SQL Monitoring and Tuning pages 0 05-JAN-14
SQL Performance Analyzer 0 05-JAN-14
SQL Tuning Advisor 0 05-JAN-14
SQL Tuning Set (system) 0 05-JAN-14
SQL Tuning Set (user) 0 05-JAN-14
But to use DBA_FEATURE_USAGE_STATISTICS you must purchase the License Pack. Just kidding.
但是要使用 DBA_FEATURE_USAGE_STATISTICS，您必须购买许可证包。只是在开玩笑。
This is all incredibly confusing. I've never seen an organisation put much effort into it.
这一切都令人难以置信的混乱。我从未见过一个组织为此付出了太多努力。
