Oracle 视图 DBA_ADVISOR_SQLA_WK_STMTS 官方解释，作用，如何使用详细说明
本站中文解释
DBA_ADVISOR_SQLA_WK_STMTS是Oracle数据库管理器（DBA）的一个视图，它可以提供数据库管理器，建议者和工具链及其活动的活动的SQL统计信息的汇总，以及与其关联的SQL工作单元。可以使用它来监视SQL诊断器和SQL推荐器的活动，以及它们使用的SQL统计和资源消耗。该视图还显示了SQL诊断提示集选择细节，以及SQL推荐器中分析的视图和表的名称。
DBA_ADVISOR_SQLA_WK_STMTS可用于监视系统中正在执行的SQL诊断器和SQL推荐器的活动、执行的状态以及每次操作的耗时等。例如，可以查询该视图以了解正在执行的SQL统计和功能的正常情况，也可以使用它来识别活动耗时比较长的SQL诊断器和SQL推荐器。另外，也可以使用它来识别更多的SQL，以便在性能分析中使用它们，以及执行更多的测试和诊断。
官方英文解释
DBA_ADVISOR_SQLA_WK_STMTS displays information about all workload objects in the database after an Access Advisor analysis operation.
Related View
USER_ADVISOR_SQLA_WK_STMTS displays information about the workload objects owned by the current user after an Access Advisor analysis operation. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the task |
|
|
|
|
Name of the task |
|
|
|
|
|
Unique identifier of the task |
|
|
|
ID of the SQL tuning set for the statement |
|
|
|
|
Name of the SQL tuning set for the statement |
|
|
|
|
Name of the workload |
|
|
|
|
|
Generated identifier of the statement |
|
|
|
|
SQL sequence |
|
|
|
|
Numerical representation of the SQL plan for the cursor. Comparing one |
|
|
|
Schema name that was used to originally build this child cursor |
|
|
|
|
Name of the user executing the statement |
|
|
|
|
Name of the module issuing the statement |
|
|
|
|
Module action for the statement |
|
|
|
|
Total CPU count (in seconds) of the executing statement |
|
|
|
|
Total number of buffer gets for the statement |
|
|
|
|
Total disk-read I/O count for the statement |
|
|
|
|
Total elapsed time (in seconds) of the executing statement |
|
|
|
|
Total number of rows processed by the statement |
|
|
|
|
Total number of times the statement was executed |
|
|
|
|
Load time of parent cursor |
|
|
|
|
Date on which the statement was last executed |
|
|
|
|
Business importance of the statement:
|
|
|
|
|
Type of the command |
|
|
|
|
Unused |
|
|
|
|
Effective period of time (in seconds) during which the SQL statement was active |
|
|
|
|
Text of the SQL statement |
|
|
|
|
Cost of executing the statement in the workload prior to the recommendations |
|
|
|
|
Cost of executing the statement in the workload after the recommendations |
|
|
|
|
Advisor-calculated importance value |
|
|
|
|
Associated recommendation identifier |
|
|
|
|
Indicates whether the statement is valid for analysis:
|
See Also:
“USER_ADVISOR_SQLA_WK_STMTS”
