Oracle 视图 DBA_ADVISOR_SQLA_REC_SUM 官方解释，作用，如何使用详细说明
本站中文解释
M
Oracle视图DBA_ADVISOR_SQLA_REC_SUMM是SQL导航器建议存储在数据字典视图的视图，提供SQL性能方面的建议摘要，帮助DBA定期检查Oracle数据库的性能情况。DBA_ADVISOR_SQLA_REC_SUMM视图存储的内容包括SQL导航器发现的SQL建议摘要以及每条建议对应的记录数，它们可用于比较建议发生次数。
要使用该视图，DBA首先要在sql_advisor_report表中查找相关信息，然后在db_advisor_sqla_rec_summ视图中根据找到的相关信息进行查询，最终可以得到每条建议出现的次数。例如：
SQL>SELECT TASK_DESC, SUGGESTION_DESC，COUNT (*) AS SUGGESTION_COUNT
FROM DBA_ADVISOR_SQLA_REC_SUMM
WHERE TASK_DESC LIKE ‘sql%’;
其中，TASK_DESC指的是SQL任务描述，SUGGESTION_DESC指的是SQL建议描述，SUGGESTION_COUNT指的是SQL建议出现的次数。通过查询结果，DBA可以根据SQL建议出现的次数决定是否要对具体SQL进行优化等操作。
官方英文解释
DBA_ADVISOR_SQLA_REC_SUM displays recommendation rollup information for all workload objects in the database after an Access Advisor analysis operation.
Related View
USER_ADVISOR_SQLA_REC_SUM displays recommendation rollup information for the workload objects owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the task |
|
|
|
|
Unique identifier of the task |
|
|
|
|
Name of the task |
|
|
|
|
Identifier of the recommendation |
|
|
|
|
Total number of statements processed during analysis |
|
|
|
|
Total cost of executing the statements in which the recommended object will be used, before the recommendations |
|
|
|
|
Total cost of executing the statements in which the recommended object will be utilized, after the recommendations have been implemented |
See Also:
“USER_ADVISOR_SQLA_REC_SUM”
