| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
DBA_ADVISOR_FINDINGS displays the findings discovered by all advisors in the database.
USER_ADVISOR_FINDINGS displays the findings discovered by the advisors 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 | |
FINDING_ID | 
NUMBER | 
NOT NULL | 
Identifier of the finding | 
FINDING_NAME | 
VARCHAR2(4000) | 
Name of the finding | |
TYPE | 
VARCHAR2(11) | 
Type of the finding:
  | 
|
TYPE_ID | 
NUMBER | 
NOT NULL | 
Numeric ID for the value in column TYPE | 
PARENT | 
NUMBER | 
NOT NULL | 
Identifier of the parent finding | 
OBJECT_ID | 
NUMBER | 
Identifier of the associated object, if any | |
IMPACT_TYPE | 
VARCHAR2(4000) | 
Impact of the finding on the system | |
IMPACT | 
NUMBER | 
Impact value | |
MESSAGE | 
VARCHAR2(4000) | 
Message describing the finding | |
MORE_INFO | 
VARCHAR2(4000) | 
Additional info associated with the finding | |
FILTERED | 
VARCHAR2(1) | 
A value of Y means that the row in the view was filtered out by a directive (or a combination of directives). A value of N means that the row was not filtered. | 
|
FLAGS | 
NUMBER | 
For internal use only by advisor framework clients | 
See Also:
"USER_ADVISOR_FINDINGS"