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 of the task |
|
|
|
|
Identifier of the task |
|
|
Name of the task |
|
|
|
The name of the task execution with which this entry (row) is associated |
|
|
|
|
Identifier of the finding |
|
|
Name of the finding |
|
|
|
Type of the finding:
|
|
|
|
|
Numeric ID for the value in column |
|
|
|
Identifier of the parent finding |
|
|
Identifier of the associated object, if any |
|
|
|
Impact of the finding on the system |
|
|
|
Impact value |
|
|
|
Message describing the finding |
|
|
|
Additional info associated with the finding |
|
|
|
A value of |
|
|
|
For internal use only by advisor framework clients |
|
|
|
The database time, in microseconds, accumulated by this finding |
|
|
|
The average number of active sessions for the finding |
|
|
|
The percentage of active sessions for this finding out of the total active sessions for the task |
|
|
|
A value of |
|
|
|
Reserved for future use |
|
|
|
Indicates whether the ASH SQL associated with the finding is an approximate query ( To get the associated query, use the |
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_ADDM.GET_ASH_QUERY
procedure