VIEW: SYS.DBA_ADVISOR_SQLW_JOURNAL

Source

View Text - Preformatted

select b.owner_name as owner,
             a.task_id as workload_id,
             b.name as workload_name,
             a.seq_id as journal_entry_seq,
             decode(a.type, 1, 'FATAL',
                            2, 'ERROR',
                            3, 'WARNING',
                            4, 'INFORMATION',
                            5, 'INFORMATION2',
                            6, 'INFORMATION3',
                            7, 'INFORMATION4',
                            8, 'INFORMATION5',
                            9, 'INFORMATION6') as journal_entry_type,
             dbms_advisor.format_message_group(a.msg_id) as journal_entry
      from wri$_adv_journal a, wri$_adv_tasks b
      where a.task_id = b.id
        and b.advisor_id = 6

View Text - HTML Formatted

SELECT B.OWNER_NAME AS OWNER
, A.TASK_ID AS WORKLOAD_ID
, B.NAME AS WORKLOAD_NAME
, A.SEQ_ID AS JOURNAL_ENTRY_SEQ
, DECODE(A.TYPE
, 1
, 'FATAL'
, 2
, 'ERROR'
, 3
, 'WARNING'
, 4
, 'INFORMATION'
, 5
, 'INFORMATION2'
, 6
, 'INFORMATION3'
, 7
, 'INFORMATION4'
, 8
, 'INFORMATION5'
, 9
, 'INFORMATION6') AS JOURNAL_ENTRY_TYPE
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(A.MSG_ID) AS JOURNAL_ENTRY
FROM WRI$_ADV_JOURNAL A
, WRI$_ADV_TASKS B
WHERE A.TASK_ID = B.ID
AND B.ADVISOR_ID = 6