Oracle教程

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

本站中文解释

Oracle视图DBA_ADVISOR_DEF_PARAMETERS可以用来查看给定顾问的默认参数值。它包含三列：

ADVISOR_NAME：定义指定顾问；

PARAMETER_NAME：定义指定参数；

PARAMETER_VALUE：定义指定参数值。

可以使用DBA_ADVISOR_DEF_PARAMETERS来检查给定顾问的当前参数设置，或确认在调用顾问时将使用哪些参数。例如：

SELECT * FROM DBA_ADVISOR_DEF_PARAMETERS
WHERE ADVISOR_NAME = ‘SQL Tuning’;

这将返回SQL Tuning Advisor的各种默认参数值。

官方英文解释

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

When a task or object is created, the parameters and their values are copied into the private parameter table.

Column Datatype NULL Description

ADVISOR_NAME

VARCHAR2(128)

NOT NULL

Name of the advisor that supports the parameter

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)

IS_SYSTEM_TASK_ONLY

VARCHAR2(1)

Indicates whether the task is a system task (Y) or not (N)

DESCRIPTION

VARCHAR2(4000)

Optional description of the parameter

EXECUTION_TYPE

VARCHAR2(128)

Type of the last execution. This information is optional for single-execution tasks.


数据运维技术 » Oracle 视图 DBA_ADVISOR_DEF_PARAMETERS 官方解释，作用，如何使用详细说明
分享到：

相关推荐