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”
