DBA_ADVISOR_LOG

DBA_ADVISOR_LOG displays information about the current state of all tasks in the database, as well as execution-specific data such as progress monitoring and completion status. The view contains one row for each task.

Related View

USER_ADVISOR_LOG displays information about the current state of the tasks owned by the current user. This view does not display the OWNER column.

ColumnDatatypeNULLDescriptionOWNERVARCHAR2(30) Owner of the taskTASK_IDNUMBERNOT NULLIdentifier of the taskTASK_NAMEVARCHAR2(30) Name of the taskEXECUTION_STARTDATE Execution start date and time of the taskEXECUTION_ENDDATE Execution end date and time of the taskSTATUS


参考文档：https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_3021.htm#REFRN23319VARCHAR2(11)