Oracle教程 2023-04-04

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

本站中文解释

Oracle视图“DBA_ADVISOR_SQLW_PARAMETERS”显示了数据库建议器（Database Advisor）对SQL调优过程中使用的参数。数据库建议器是Oracle使用的基于自定义的调优策略的工具，用于帮助管理员调优SQL。此视图的的一列也可以在数据字典视图V$SQL_OPTIMIZER_ENV中找到。

此视图常被DBA使用来调整调优过程，从而根据特定的需求对数据库做出有效的决策。

使用方法：
FIRST，要查看DBA_ADVISOR_SQLW_PARAMETERS视图，需要使用以下SELECT语句：

SELECT * FROM DBA_ADVISOR_SQLW_PARAMETERS;

其次，可以使用以下SELECT语句来实现自定义搜索：

SELECT * FROM DBA_ADVISOR_SQLW_PARAMETERS WHERE PARAMETER=;

最后，如果需要更新某项参数，DBA可以使用以下语句：

EXEC DBMS_SQLTUNE.UPDATE_SQL_TUNING_SET (sqlset_name => ”, sql_text => ”, use_existing_sqlset => true);

官方英文解释

DBA_ADVISOR_SQLW_PARAMETERS displays all workload parameters and their current values in the database.

Related View

USER_ADVISOR_SQLW_PARAMETERS displays the workload parameters and their current values owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the task or workload object
`WORKLOAD_ID`	`NUMBER`	`NOT NULL`	Unique identifier number of the workload object
`WORKLOAD_NAME`	`VARCHAR2(128)`		Name of the workload object
`PARAMETER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the parameter
`PARAMETER_VALUE`	`VARCHAR2(4000)`	`NOT NULL`	Value of the parameter. Numeric parameter values are converted to a string equivalent. Possible keywords as values: `ALL` `UNLIMITED` `UNUSED`
`PARAMETER_TYPE`	`VARCHAR2(10)`		Datatype of the parameter: `NUMBER` – Numeric value `STRING` – String value. If the string contains special characters, then it will be enclosed in single quotes. `STRINGLIST` – Comma-separated list of string elements. If a string element contains a comma or other special characters, then the element will be enclosed in single quotes. `TABLE` – Single table reference. A reference contains a schema name, followed by an optional table name. If the table name is omitted or is the character `%`, then the table name is interpreted as a wildcard. SQL quoted identifiers are supported. `TABLELIST` – List of one or more comma-separated table references. A reference contains a schema name, followed by an optional table name. If the table name is omitted or is the character `%`, then the table name is interpreted as a wildcard. SQL quoted identifiers are supported.
`DESCRIPTION`	`VARCHAR2(4000)`		Parameter description

本站中文解释

官方英文解释

相关推荐