select
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  USERNAME,                                -- USERNAME VARCHAR2(30)
  OPNAME,                                  -- OPNAME VARCHAR2(64)
  ADVISOR_NAME,                            -- ADVISOR_NAME VARCHAR2(64)
  TASK_ID,                                 -- TASK_ID NUMBER
  TARGET_DESC,                             -- TARGET_DESC VARCHAR2(32)
  SOFAR,                                   -- SOFAR NUMBER
  TOTALWORK,                               -- TOTALWORK NUMBER
  UNITS,                                   -- UNITS VARCHAR2(32)
  BENEFIT_SOFAR,                           -- BENEFIT_SOFAR NUMBER
  BENEFIT_MAX,                             -- BENEFIT_MAX NUMBER
  FINDINGS,                                -- FINDINGS NUMBER
  RECOMMENDATIONS,                         -- RECOMMENDATIONS NUMBER
  TIME_REMAINING,                          -- TIME_REMAINING NUMBER
  START_TIME,                              -- START_TIME DATE
  LAST_UPDATE_TIME,                        -- LAST_UPDATE_TIME DATE
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  ADVISOR_METRIC1,                         -- ADVISOR_METRIC1 NUMBER
  METRIC1_DESC,                            -- METRIC1_DESC VARCHAR2(64)
  EXECUTION_TYPE                           -- EXECUTION_TYPE VARCHAR2(64)
from
  GV$ADVISOR_PROGRESS
where
  inst_id = USERENV('Instance')