VIEW: SYS.DBA_ADDM_TASKS

Source

View Text - Preformatted

select at."OWNER",at."TASK_ID",at."TASK_NAME",at."DESCRIPTION",at."ADVISOR_NAME",at."CREATED",at."LAST_MODIFIED",at."PARENT_TASK_ID",at."PARENT_RXEC_ID",at."LAST_EXECUTION",at."EXECUTION_TYPE",at."EXECUTION_TYPE#",at."EXECUTION_DESCRIPTION",at."EXECUTION_START",at."EXECUTION_END",at."STATUS",at."STATUS_MESSAGE",at."PCT_COMPLETION_TIME",at."PROGRESS_METRIC",at."METRIC_UNITS",at."ACTIVITY_COUNTER",at."RECOMMENDATION_COUNT",at."ERROR_MESSAGE",at."SOURCE",at."HOW_CREATED",at."READ_ONLY",at."SYSTEM_TASK",at."ADVISOR_ID",at."STATUS#",
             a.dbid as dbid,
             a.dbname as dbname,
             a.dbversion as dbversion,
             a.analysis_version as analysis_version,
             a.begin_snap_id as begin_snap_id,
             a.begin_time as begin_time,
             a.end_snap_id as end_snap_id,
             a.end_time as end_time,
             a.requested_analysis as requested_analysis,
             a.actual_analysis as actual_analysis,
             a.database_time as database_time,
             a.active_sessions as active_sessions,
             a.meter_level as meter_level,
             a.fdg_count as fdg_count
      from  wri$_adv_addm_tasks a, dba_advisor_tasks at
      where at.task_id = a.task_id
        and at.status = 'COMPLETED'

View Text - HTML Formatted

SELECT AT."OWNER"
, AT."TASK_ID"
, AT."TASK_NAME"
, AT."DESCRIPTION"
, AT."ADVISOR_NAME"
, AT."CREATED"
, AT."LAST_MODIFIED"
, AT."PARENT_TASK_ID"
, AT."PARENT_RXEC_ID"
, AT."LAST_EXECUTION"
, AT."EXECUTION_TYPE"
, AT."EXECUTION_TYPE#"
, AT."EXECUTION_DESCRIPTION"
, AT."EXECUTION_START"
, AT."EXECUTION_END"
, AT."STATUS"
, AT."STATUS_MESSAGE"
, AT."PCT_COMPLETION_TIME"
, AT."PROGRESS_METRIC"
, AT."METRIC_UNITS"
, AT."ACTIVITY_COUNTER"
, AT."RECOMMENDATION_COUNT"
, AT."ERROR_MESSAGE"
, AT."SOURCE"
, AT."HOW_CREATED"
, AT."READ_ONLY"
, AT."SYSTEM_TASK"
, AT."ADVISOR_ID"
, AT."STATUS#"
, A.DBID AS DBID
, A.DBNAME AS DBNAME
, A.DBVERSION AS DBVERSION
, A.ANALYSIS_VERSION AS ANALYSIS_VERSION
, A.BEGIN_SNAP_ID AS BEGIN_SNAP_ID
, A.BEGIN_TIME AS BEGIN_TIME
, A.END_SNAP_ID AS END_SNAP_ID
, A.END_TIME AS END_TIME
, A.REQUESTED_ANALYSIS AS REQUESTED_ANALYSIS
, A.ACTUAL_ANALYSIS AS ACTUAL_ANALYSIS
, A.DATABASE_TIME AS DATABASE_TIME
, A.ACTIVE_SESSIONS AS ACTIVE_SESSIONS
, A.METER_LEVEL AS METER_LEVEL
, A.FDG_COUNT AS FDG_COUNT
FROM WRI$_ADV_ADDM_TASKS A
, DBA_ADVISOR_TASKS AT
WHERE AT.TASK_ID = A.TASK_ID
AND AT.STATUS = 'COMPLETED'