国外主机测评 - 国外VPS，国外服务器，国外云服务器，测评及优惠码
本站中文解释
Oracle视图DBA_ADVISOR_SQLW_STMTS用于分析和收集SQL Workload Manager（SQL Workload Manager）会话的信息(AVGSECS_CUMM, SQLWORKLOAD_CUMM)。此视图报告有关特定SQL语句或性能分析时间段中应用程序会话的信息，包括每个会话应用的累计/平均SQL处理时间。该视图可用于优化控件SQL Workload Manager决策、调查性能问题或监视环境。
使用此视图，可以查询一段时间内所有会话的累计处理时间，以及该期间内每个会话的平均处理时间，以及SQL语句的应用情况和执行次数。
例如，可以使用以下查询来查询特定时间段内最耗时的会话：
SELECT
SID,
sum(avgsecs_cumm) AS AVG_TIME
FROM
dba_advisor_sqlw_stmts
WHERE
startdate_time BETWEEN ’20-05-01′ AND ’20-05-14′
GROUP BY
SID
ORDER BY
AVG_TIME DESC;
官方英文解释
DBA_ADVISOR_SQLW_STMTS displays rows that correspond to all statements in the workload.
All columns are guaranteed to be non-null.
Related View
USER_ADVISOR_SQLW_STMTS displays rows that correspond to the statements in the workload 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 |
|
|
|
Name of the workload |
|
|
|
|
|
Generated identifier of the statement |
|
|
|
Hash value for the parent statement in the cache |
|
|
|
|
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 |
|
|
|
|
Cost of executing the statement in the workload prior to the recommendations |
|
|
|
|
Date on which the statement was last executed |
|
|
|
|
Priority of the statement:
|
|
|
|
|
Type of the command |
|
|
|
|
Unused |
|
|
|
|
Text of the SQL statement |
|
|
|
|
Indicates whether the statement is valid for analysis:
|
See Also:
“USER_ADVISOR_SQLW_STMTS”
