GV$ADVISOR_PROGRESS

select
inst_id,                 -- INST_ID NUMBER
ksulosno,                -- SID NUMBER
ksulosrn,                -- SERIAL# NUMBER
ksulounm,                -- USERNAME VARCHAR2(30)
ksulopna,                -- OPNAME VARCHAR2(64)
ksuloif5d,               -- ADVISOR_NAME VARCHAR2(64)
ksuloctx,                -- TASK_ID NUMBER
ksulotde,                -- TARGET_DESC VARCHAR2(32)
ksulosfr,                -- SOFAR NUMBER
ksulotot,                -- TOTALWORK NUMBER
ksulouni,                -- UNITS VARCHAR2(32)
ksuloif3,                -- BENEFIT_SOFAR NUMBER
ksuloif4,                -- BENEFIT_MAX NUMBER
ksuloif0,                -- FINDINGS NUMBER
ksuloif1,                -- RECOMMENDATIONS NUMBER
ksuloif2,                -- TIME_REMAINING NUMBER
to_date                  -- START_TIME DATE
  (ksulostm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date                  -- LAST_UPDATE_TIME DATE
  (ksulolut, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
ksuloetm,                -- ELAPSED_SECONDS NUMBER
decode                   -- ADVISOR_METRIC1 NUMBER
  (ksuloif6d, null, to_number (null), ksuloif6),
ksuloif6d                -- METRIC1_DESC VARCHAR2(64)
from
x$ksulop 
where
ksulopna in ('Advisor')
home |  up  |  mailbox