Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_ADVISOR_RATIONALE

DBA_ADVISOR_RATIONALE displays information about the rationales for all recommendations in the database.

Related View

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
EXECUTION_NAME VARCHAR2(30)   The name of the task execution with which this entry (row) is associated
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:
  • TEXT - Text sentence for descriptive messages. The ATTR1 column contains the text.

  • CHART - Chart containing data to be displayed. The ATTR1 column contains the data.

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