Oracle 视图 DBA_ADVISOR_RATIONALE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ADVISOR_RATIONALE，它描述了一些自动化管理建议以及让DBA更好地理解自动服务工具建议的原因。该视图通过将各种可用的SQL和ADDM报告的指导思想的信息组合在一起，以清楚地汇总其建议。
使用此视图，DBA可通过检查它们的视图来查看关于某个建议的建议原因。例如，基于查询指标分析结果，DBA可以查看相应建议的相关勾选原因。
使用DBA_ADVISOR_RATIONALE视图，DBA可以了解Oracle自动服务工具对其系统做出哪些建议，以及这些建议的支撑理由。因此，DBA_ADVISOR_RATIONALE视图为DBA提供了一种与Oracle自动服务工具交互的方式，帮助他们掌握系统的性能状况以及Oracle自动服务工具提出的建议。
官方英文解释
DBA_ADVISOR_RATIONALE displays information about the rationales for all recommendations in the database.
Related View
USER_ADVISOR_RATIONALE displays information about the rationales for the recommendations owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the task |
|
|
|
|
|
Identifier of the task |
|
|
|
Name of the task |
|
|
|
|
The name of the task execution with which this entry (row) is associated |
|
|
|
|
Recommendation associated with the rationale |
|
|
|
|
|
Unique identifier for the rationale |
|
|
|
Impact on the system due to the problem described in the rationale. The impact can be described in terms of time, cost, or % degradation. |
|
|
|
|
Calculated impact value |
|
|
|
|
Message containing an overview of the rationale |
|
|
|
|
Identifier of an object specified in the |
|
|
|
|
Type of the rationale; defines what data exists in the attribute columns and how to interpret it:
|
|
|
|
|
Parameters defining the rationale |
|
|
|
|
Parameters defining the rationale |
|
|
|
|
Parameters defining the rationale |
|
|
|
|
Parameters defining the rationale |
|
|
|
|
Parameters defining the rationale |
See Also:
“USER_ADVISOR_RATIONALE”
