VIEW: SYS.USER_ADVISOR_FINDINGS

Source

View Text - Preformatted

select a.task_id as task_id,
            b.name as task_name,
            a.exec_name as execution_name,
            a.id as finding_id,
            dbms_advisor.format_message(a.name_msg_code) as finding_name,
            decode (a.type,
                    1, 'PROBLEM',
                    2, 'SYMPTOM',
                    3, 'ERROR',
                    4, 'INFORMATION',
                    5, 'WARNING')  as type,
            a.type as type_id,
            a.parent as parent,
            a.obj_id as object_id,
            dbms_advisor.format_message_group(a.impact_msg_id) as impact_type,
            a.impact_val as impact,
            dbms_advisor.format_message_group(a.msg_id, a.type) as message,
            dbms_advisor.format_message_group(a.more_info_id) as more_info,
            nvl(a.filtered, 'N') as filtered,
            a.flags as flags
    from wri$_adv_findings a, wri$_adv_tasks b
    where a.task_id = b.id
      and b.owner# = userenv('SCHEMAID')
        and bitand(b.property,6) = 4

View Text - HTML Formatted

SELECT A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.EXEC_NAME AS EXECUTION_NAME
, A.ID AS FINDING_ID
, DBMS_ADVISOR.FORMAT_MESSAGE(A.NAME_MSG_CODE) AS FINDING_NAME
, DECODE (A.TYPE
, 1
, 'PROBLEM'
, 2
, 'SYMPTOM'
, 3
, 'ERROR'
, 4
, 'INFORMATION'
, 5
, 'WARNING') AS TYPE
, A.TYPE AS TYPE_ID
, A.PARENT AS PARENT
, A.OBJ_ID AS OBJECT_ID
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(A.IMPACT_MSG_ID) AS IMPACT_TYPE
, A.IMPACT_VAL AS IMPACT
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(A.MSG_ID
, A.TYPE) AS MESSAGE
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(A.MORE_INFO_ID) AS MORE_INFO
, NVL(A.FILTERED
, 'N') AS FILTERED
, A.FLAGS AS FLAGS
FROM WRI$_ADV_FINDINGS A
, WRI$_ADV_TASKS B
WHERE A.TASK_ID = B.ID
AND B.OWNER# = USERENV('SCHEMAID')
AND BITAND(B.PROPERTY
, 6) = 4