Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_ADVISOR_JOURNAL

DBA_ADVISOR_JOURNAL displays the journal entries for all tasks in the database.

Related View

USER_ADVISOR_JOURNAL displays the journal entries for the tasks owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the task
TASK_ID NUMBER NOT NULL Identifier of the task or workload object
TASK_NAME VARCHAR2(30)   Name of the task or workload object
EXECUTION_NAME VARCHAR2(30)   The name of the task execution with which this entry (row) is associated
JOURNAL_ENTRY_SEQ NUMBER NOT NULL Sequence number of the journal entry (unique for each task). This sequence number is used to order the data.
JOURNAL_ENTRY_TYPE VARCHAR2(12)   Type of the task:
  • FATAL

  • ERROR

  • WARNING

  • INFORMATION

  • INFORMATION[2 | 3 | 4 | 5 | 6]

JOURNAL_ENTRY VARCHAR2(4000)   Entry in the journal