GV$ADVISOR_PROGRESS

select
inst_id,                 -- INST_ID NUMBER
ksulosno,                -- SID NUMBER
ksulosrn,                -- SERIAL# NUMBER
ksulounm,                -- USERNAME VARCHAR2(30)
ksulopna,                -- OPNAME VARCHAR2(64)
ksuloctx,                -- TASK_ID NUMBER
ksulotna,                -- TARGET VARCHAR2(64)
ksulotde,                -- TARGET_DESC VARCHAR2(32)
ksulosfr,                -- SOFAR NUMBER
ksulotot,                -- TOTALWORK NUMBER
ksulouni,                -- UNITS VARCHAR2(32)
ksuloif0,                -- FINDINGS 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'),
decode                   -- TIME_REMAINING NUMBER
  (sign (ksulotot-ksulosfr), -1, to_number (NULL), decode (ksulosfr, 0, to_number (NULL), round (ksuloetm* ((ksulotot-ksulosfr) /ksulosfr)))),
ksuloetm,                -- ELAPSED_SECONDS NUMBER
ksuloif1d,               -- INFO1_DESC VARCHAR2(64)
decode                   -- INFO1 NUMBER
  (ksuloif1d, null, to_number (null), ksuloif1),
ksuloif2d,               -- INFO2_DESC VARCHAR2(64)
decode                   -- INFO2 NUMBER
  (ksuloif2d, null, to_number (null), ksuloif2),
ksuloif3d,               -- INFO3_DESC VARCHAR2(64)
decode                   -- INFO3 NUMBER
  (ksuloif3d, null, to_number (null), ksuloif3),
ksuloif4d,               -- INFO4_DESC VARCHAR2(64)
decode                   -- INFO4 NUMBER
  (ksuloif4d, null, to_number (null), ksuloif4) 
from
x$ksulop 
where
ksulopna in ('SQL Tune')
home |  up  |  mailbox