Oracle 视图 DBA_ADVISOR_SQLA_WK_STMTS 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 DBA_ADVISOR_SQLA_WK_STMTS 官方解释，作用，如何使用详细说明 10-15

本站中文解释

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`	`VARCHAR2(128)`		Owner of the task
`TASK_NAME`	`VARCHAR2(128)`		Name of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the task
`SQLSET_ID`	`NUMBER`		ID of the SQL tuning set for the statement
`SQLSET_NAME`	`VARCHAR2(128)`		Name of the SQL tuning set for the statement
`WORKLOAD_NAME`	`VARCHAR2(128)`		Name of the workload
`SQL_ID`	`VARCHAR(13)`	`NOT NULL`	Generated identifier of the statement
`SQL_SEQ`	`NUMBER`	`NOT NULL`	SQL sequence
`PLAN_HASH_VALUE`	`NUMBER`	`NOT NULL`	Numerical representation of the SQL plan for the cursor. Comparing one `PLAN_HASH_VALUE` to another easily identifies whether or not two plans are the same (rather than comparing the two plans line-by-line).
`PARSING_SCHEMA_NAME`	`VARCHAR2(128)`		Schema name that was used to originally build this child cursor
`USERNAME`	`VARCHAR2(128)`		Name of the user executing the statement
`MODULE`	`VARCHAR2(64)`		Name of the module issuing the statement
`ACTION`	`VARCHAR2(64)`		Module action for the statement
`CPU_TIME`	`NUMBER`		Total CPU count (in seconds) of the executing statement
`BUFFER_GETS`	`NUMBER`		Total number of buffer gets for the statement
`DISK_READS`	`NUMBER`		Total disk-read I/O count for the statement
`ELAPSED_TIME`	`NUMBER`		Total elapsed time (in seconds) of the executing statement
`ROWS_PROCESSED`	`NUMBER`		Total number of rows processed by the statement
`EXECUTIONS`	`NUMBER`		Total number of times the statement was executed
`FIRST_LOAD_TIME`	`DATE`		Load time of parent cursor
`LAST_EXECUTION_DATE`	`DATE`		Date on which the statement was last executed
`PRIORITY`	`NUMBER`		Business importance of the statement: `1` – High `2` – Medium `3` – Low
`COMMAND_TYPE`	`NUMBER`		Type of the command
`STAT_PERIOD`	`NUMBER`		Unused
`ACTIVE_STAT_PERIOD`	`NUMBER`		Effective period of time (in seconds) during which the SQL statement was active
`SQL_TEXT`	`CLOB`		Text of the SQL statement
`PRECOST`	`NUMBER`		Cost of executing the statement in the workload prior to the recommendations
`POSTCOST`	`NUMBER`		Cost of executing the statement in the workload after the recommendations
`IMPORTANCE`	`NUMBER`		Advisor-calculated importance value
`REC_ID`	`NUMBER`		Associated recommendation identifier
`VALIDATED`	`NUMBER`		Indicates whether the statement is valid for analysis: `0` – Statement will not be analyzed by the `EXECUTE_TASK` procedure. Typically, the statement references one or more tables that do not have valid statistics. To correct this problem, ensure that the tables have valid statistics and execute the `RESET_SQLWKLD` procedure on the current workload. `1`– Statement is eligible for analysis by the `EXECUTE_TASK` procedure

广州明生堂生物科技有限公司

Oracle 视图 DBA_ADVISOR_SQLA_WK_STMTS 官方解释，作用，如何使用详细说明

本站中文解释

官方英文解释