VIEW: SYS.CDB_ADVISOR_TASKS

Source

View Text - Preformatted

SELECT "OWNER","TASK_ID","TASK_NAME","DESCRIPTION","ADVISOR_NAME","CREATED","LAST_MODIFIED","PARENT_TASK_ID","PARENT_RXEC_ID","LAST_EXECUTION","EXECUTION_TYPE","EXECUTION_TYPE#","EXECUTION_DESCRIPTION","EXECUTION_START","EXECUTION_END","STATUS","STATUS_MESSAGE","PCT_COMPLETION_TIME","PROGRESS_METRIC","METRIC_UNITS","ACTIVITY_COUNTER","RECOMMENDATION_COUNT","ERROR_MESSAGE","SOURCE","HOW_CREATED","READ_ONLY","SYSTEM_TASK","ADVISOR_ID","STATUS#","CON_ID" FROM CONTAINERS("SYS"."DBA_ADVISOR_TASKS")

View Text - HTML Formatted

SELECT "OWNER"
, "TASK_ID"
, "TASK_NAME"
, "DESCRIPTION"
, "ADVISOR_NAME"
, "CREATED"
, "LAST_MODIFIED"
, "PARENT_TASK_ID"
, "PARENT_RXEC_ID"
, "LAST_EXECUTION"
, "EXECUTION_TYPE"
, "EXECUTION_TYPE#"
, "EXECUTION_DESCRIPTION"
, "EXECUTION_START"
, "EXECUTION_END"
, "STATUS"
, "STATUS_MESSAGE"
, "PCT_COMPLETION_TIME"
, "PROGRESS_METRIC"
, "METRIC_UNITS"
, "ACTIVITY_COUNTER"
, "RECOMMENDATION_COUNT"
, "ERROR_MESSAGE"
, "SOURCE"
, "HOW_CREATED"
, "READ_ONLY"
, "SYSTEM_TASK"
, "ADVISOR_ID"
, "STATUS#"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_ADVISOR_TASKS")