Oracle 视图 DBA_ADVISOR_SQLW_TEMPLATES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图是安装数据字典视图，它是适用于定制SQL优化报告的SQL模板视图。该视图存储系统自动生成的SQL优化建议模板，模板可以用作SQL Workload Manager (SWLM) rulesets的源和目的的SQL，以实现性能和资源优化。可以通过在DBA_ADVISOR_SQLW_TEMPLATES视图中查询，将SWL模式导入到rule set中来使用，以便进行SQL优化。
官方英文解释
DBA_ADVISOR_SQLW_TEMPLATES displays an aggregated picture of all SQLWkld template objects in the database.
Related View
USER_ADVISOR_SQLW_TEMPLATES displays an aggregated picture of the SQLWkld template 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 |
|
|
|
Optional object or template on which the object was based |
|
|
|
|
Indicates whether the workload template can be modified or deleted ( |
See Also:
“USER_ADVISOR_SQLW_TEMPLATES”
