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

E40402-10
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
PDF · Mobi · ePub

DBA_ADDM_FINDINGS

DBA_ADDM_FINDINGS displays the ADDM findings discovered by all advisors in the database. Each row for ADDM tasks in the related DBA_ADVISOR_FINDINGS view has a corresponding row in this view.

Related View

USER_ADDM_FINDINGS displays the ADDM findings discovered by the advisors owned by the current user. Each row for ADDM tasks in the related USER_ADVISOR_FINDINGS view has a corresponding row in this view. The USER_ADDM_FINDINGS 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

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 CHAR(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
DATABASE_TIME NUMBER   The database time, in microseconds, accumulated by this finding
ACTIVE_SESSIONS NUMBER   The average number of active sessions for the finding
PERC_ACTIVE_SESS NUMBER   The percentage of active sessions for this finding out of the total active sessions for the task
IS_AGGREGATE CHAR(1)   A value of Y means that this finding is created for global/continental ADDM as an aggregate of local ADDM findings. Otherwise, the value is N.
METER_LEVEL VARCHAR2(6)   Reserved for future use
QUERY_IS_APPROX CHAR(1)   Indicates whether the ASH SQL associated with the finding is an approximate query (Y) or an exact query (N).

To get the associated query, use the TASK_NAME and FINDING_ID columns from this view and call the PL/SQL function DBMS_ADDM.GET_ASH_QUERY(task_name, finding_id).