Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_ADVISOR_PARAMETERS
displays the parameters and their current values for all tasks in the database.
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:
|
PARAMETER_TYPE |
VARCHAR2(10) |
Datatype of the parameter:
|