VIEW: SYS.DBA_ADVISOR_RATIONALE

Source

View Text - Preformatted

select b.owner_name as owner,
             a.task_id as task_id,
             b.name as task_name,
             a.exec_name as execution_name,
             a.rec_id as rec_id,
             a.id as rationale_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) as message,
             a.obj_id as object_id,
             a.type,
             a.attr1 as attr1,
             a.attr2 as attr2,
             a.attr3 as attr3,
             a.attr4 as attr4,
             a.attr5 as attr5
      from wri$_adv_rationale a, wri$_adv_tasks b
      where a.task_id = b.id
        and bitand(b.property,6) = 4

View Text - HTML Formatted

SELECT B.OWNER_NAME AS OWNER
, A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.EXEC_NAME AS EXECUTION_NAME
, A.REC_ID AS REC_ID
, A.ID AS RATIONALE_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) AS MESSAGE
, A.OBJ_ID AS OBJECT_ID
, A.TYPE
, A.ATTR1 AS ATTR1
, A.ATTR2 AS ATTR2
, A.ATTR3 AS ATTR3
, A.ATTR4 AS ATTR4
, A.ATTR5 AS ATTR5
FROM WRI$_ADV_RATIONALE A
, WRI$_ADV_TASKS B
WHERE A.TASK_ID = B.ID
AND BITAND(B.PROPERTY
, 6) = 4