Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 | |
FINDING_ID |
NUMBER |
NOT NULL |
Identifier of the finding |
TYPE |
VARCHAR2(11) |
Type of the finding:
| |
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 |