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"