VIEW: SYS.USER_ADVISOR_JOURNAL

Source

View Text - Preformatted

select a.task_id as task_id,
             b.name as task_name,
             a.exec_name as execution_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 bitand(b.property,4) = 4
        and b.owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.EXEC_NAME AS EXECUTION_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 BITAND(B.PROPERTY
, 4) = 4
AND B.OWNER# = USERENV('SCHEMAID')