GV$PROXY_ARCHIVEDLOG definition in Oracle 9i / www.oracledba.ru
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+4), 0, 'A', 1, 'D', 2, 'X', 4, 'U', '?'),
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