DBA_ADVISOR_RATIONALE
displays information about the rationales for all recommendations in the database.
USER_ADVISOR_RATIONALE
displays information about the rationales for the recommendations owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the task | |
TASK_ID |
NUMBER |
NOT NULL |
Identifier of the task |
TASK_NAME |
VARCHAR2(30) |
Name of the task | |
REC_ID |
NUMBER |
Recommendation associated with the rationale | |
RATIONALE_ID |
NUMBER |
NOT NULL |
Unique identifier for the rationale |
IMPACT_TYPE |
VARCHAR2(4000) |
Impact on the system due to the problem described in the rationale. The impact can be described in terms of time, cost, or % degradation. | |
IMPACT |
NUMBER |
Calculated impact value | |
MESSAGE |
VARCHAR2(4000) |
Message containing an overview of the rationale | |
OBJECT_ID |
NUMBER |
Identifier of an object specified in the DBA_ADVISOR_OBJECTS view |
|
TYPE |
VARCHAR2(30) |
Type of the rationale; defines what data exists in the attribute columns and how to interpret it:
|
|
ATTR1 |
VARCHAR2(4000) |
Parameters defining the rationale | |
ATTR2 |
VARCHAR2(4000) |
Parameters defining the rationale | |
ATTR3 |
VARCHAR2(4000) |
Parameters defining the rationale | |
ATTR4 |
VARCHAR2(4000) |
Parameters defining the rationale | |
ATTR5 |
CLOB |
Parameters defining the rationale |
See Also:
"USER_ADVISOR_RATIONALE"