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`
`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.
`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)`		???