DBA_ADVISOR_PARAMETERS

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

Related View

USER_ADVISOR_PARAMETERS displays the 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(30)`		Owner of the task or workload object
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique identifier number of the task or workload object
`TASK_NAME`	`VARCHAR2(30)`		Name of the task or workload object
`PARAMETER_NAME`	`VARCHAR2(30)`	`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, 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.

See Also:

"USER_ADVISOR_PARAMETERS"