Oracle 视图 DBA_ADVISOR_SQLW_SUM 官方解释，作用，如何使用详细说明
本站中文解释
MARY
Oracle视图DBA_ADVISOR_SQLW_SUMMARY表示SQL建议器的收集的SQL统计信息的汇总，可以分析出最终执行的SQL最大、最小、中间值统计数据，以及当前系统能够处理的最大、最小和中间值。用户可以利用这个视图探讨SQL的性能问题。
使用方法：一般情况下，用户可以在DBA_ADVISOR_SQLW_SUMMARY视图上先选出SQL语句，再找出它相应的SQL ID，进而在 SQL_PLAN_OVERVIEW 视图上进一步分析该语句的执行计划。
官方英文解释
DBA_ADVISOR_SQLW_SUM displays an aggregated picture of all SQLWkld workload objects in the database.
Related View
USER_ADVISOR_SQLW_SUM displays an aggregated picture of the SQLWkld workload objects owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| Owner of the workload object | |
|
|
| Unique identifier number of the workload object |
|
| Unique name of the workload | |
|
| User-specified description of the workload | |
|
|
| Date on which the workload object was created |
|
|
| Date of last update to the current workload |
|
| Number of | |
|
| Number of | |
|
| Number of | |
|
| Number of | |
|
| Number of | |
|
| Optional name that identifies the creator of the object | |
|
| Optional object or template on which the object was based | |
|
| Workload data source | |
|
| Indicates whether or not the workload can be modified or deleted ( |
See Also:
“USER_ADVISOR_SQLW_SUM”
编辑：一起学习网
标签：视图,用户可以,语句,最小,英文