GV$PROXY_ARCHIVEDLOG

select
inst_id,                 -- INST_ID NUMBER
pcrid,                   -- RECID NUMBER
pcstm,                   -- STAMP NUMBER
pcdev,                   -- DEVICE_TYPE VARCHAR2(17)
pchdl,                   -- HANDLE VARCHAR2(513)
pccmt,                   -- COMMENTS VARCHAR2(81)
pcmdh,                   -- MEDIA VARCHAR2(65)
pcmpl,                   -- MEDIA_POOL NUMBER
decode                   -- STATUS VARCHAR2(1)
  (bitand (pcflg, 1+2), 1, 'D', 2, 'X', 0, 'A', '?'),
decode                   -- DELETED VARCHAR2(3)
  (bitand (pcflg, 1), 1, 'YES', 'NO'),
pathp,                   -- THREAD# NUMBER
paseq,                   -- SEQUENCE# NUMBER
to_number (parls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (parlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (palos),       -- FIRST_CHANGE# NUMBER
to_date                  -- FIRST_TIME DATE
  (palot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (panxs),       -- NEXT_CHANGE# NUMBER
to_date                  -- NEXT_TIME DATE
  (panxt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
pabct,                   -- BLOCKS NUMBER
pabsz,                   -- BLOCK_SIZE NUMBER
to_date                  -- START_TIME DATE
  (pctsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date                  -- COMPLETION_TIME DATE
  (pctim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
(to_date                 -- ELAPSED_SECONDS NUMBER
  (pctim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') - to_date (pctsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')) *86400 
from
x$kccpa
home |  up  |  mailbox