Oracle教程 2023-04-05

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

本站中文解释

Oracle视图DBA_ADVISOR_PARAMETERS是用来查询所有SQL优化器参数的用途的视图。该视图的记录由ADVISOR_ID列和PARAMETER_VALUE列组成，其中ADVISOR_ID列指定使用该视图的SQL优化器，而PARAMETER_VALUE列则保存为SQL优化器设置的参数值。使用该视图时，可以通过查询该视图获取特定SQL优化器的参数值，查询SQL优化器参数的语法可以如下所示：

SELECT parameter_value FROM dba_advisor_parameters WHERE advisor_id = ”;

官方英文解释

DBA_ADVISOR_PARAMETERS displays all task parameters and their current values in the database.

This data is accessible by all tasks.

Related View

USER_ADVISOR_PARAMETERS displays the task parameters and their current values for the tasks 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
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique identifier number of the task or workload object
`TASK_NAME`	`VARCHAR2(128)`		Name of the task or 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 will contain 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 will contain 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.
`IS_DEFAULT`	`VARCHAR2(1)`		Indicates whether the parameter value is set to the advisor’s default value (`Y`) or not (`N`)
`IS_OUTPUT`	`VARCHAR2(1)`		Indicates whether the task execution process sets the parameter value (`Y`) or not (`N`)
`IS_MODIFIABLE_ANYTIME`	`VARCHAR2(1)`		Indicates whether the parameter value can be modified when the task is not in its initial state (`Y`) or not (`N`)
`DESCRIPTION`	`VARCHAR2(4000)`		Optional description of the parameter
`EXECUTION_TYPE`	`VARCHAR2(128)`		For advisors supporting multiple executions, the type of execution this parameter pertains to

本站中文解释

官方英文解释

相关推荐