4.16 DBA_ADVISOR_DEF_PARAMETERS
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 |
---|---|---|---|
|
|
|
Name of the advisor that supports the parameter |
|
|
|
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 ( |
|
|
|
Indicates whether the task is a system task ( |
|
|
|
Optional description of the parameter |
|
|
|
Type of the last execution. This information is optional for single-execution tasks. |