4.27 DBA_ADVISOR_PARAMETERS
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 of the task or workload object |
|
|
|
Unique identifier number of the task or workload object |
|
|
|
Name of the task or workload object |
|
|
|
Name of the parameter |
|
|
|
Value of the parameter. Numeric parameter values are converted to a string equivalent. Possible keywords as values:
|
|
|
|
Datatype of the parameter:
|
|
|
|
Indicates whether the parameter value is set to the advisor's default value ( |
|
|
|
Indicates whether the task execution process sets the parameter value ( |
|
|
|
Indicates whether the parameter value can be modified when the task is not in its initial state ( |
|
|
|
Optional description of the parameter |
|
|
|
For advisors supporting multiple executions, the type of execution this parameter pertains to |
See Also: