Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
=================================================================
Oracle 11gR1
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:
·
PROBLEM
·
SYMPTOM
·
ERROR
·
INFORMATION | |
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. |
Note:
1.
SELECT owner, task_name, type, message FROM dba_advisor_findings;
OWNER
|
TASK_NAME
|
TYPE
|
MESSAGE
|
SYS
|
ADDM:2334540272_1_18683
|
PROBLEM
|
Time spent on the CPU by the instance was responsible for a substantial part of database time.
|
SYS
|
ADDM:2334540272_1_18683
|
PROBLEM
|
Wait event "SQL*Net more data to client" in wait class "Network" was consuming significant database time.
|
SYS
|
ADDM:2334540272_1_18683
|
SYMPTOM
|
Wait class "Network" was consuming significant database time.
|
SYS
|
ADDM:2334540272_1_18683
|
PROBLEM
|
Individual SQL statements responsible for significant user I/O wait were found.
|
SYS
|
ADDM:2334540272_1_18683
|
SYMPTOM
|
Wait class "User I/O" was consuming significant database time.
|
SYS
|
ADDM:2334540272_1_18683
|
PROBLEM
|
Individual database segments responsible for significant user I/O wait were found.
|
