DBA_ADVISOR_SQLW_JOURNAL displays the journal entries for all workload objects in the database.

Related View

USER_ADVISOR_SQLW_JOURNAL displays the journal entries for the workload objects owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the workload
WORKLOAD_ID NUMBER NOT NULL Identifier number of the workload object
WORKLOAD_NAME VARCHAR2(30)   Name of the workload object
JOURNAL_ENTRY_SEQ NUMBER NOT NULL Sequence number of the journal entry (unique for each workload). The sequence number is used to order the data.
JOURNAL_ENTRY_TYPE VARCHAR2(12)   Type of the task:




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

JOURNAL_ENTRY VARCHAR2(4000)   Entry in the journal