GV$RECOVERY_PROGRESS

select
inst_id,                 -- INST_ID NUMBER
to_date                  -- START_TIME DATE
  (ksulostm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
ksulopna,                -- TYPE VARCHAR2(64)
ksulotde,                -- ITEM VARCHAR2(32)
ksulouni,                -- UNITS VARCHAR2(32)
ksulosfr,                -- SOFAR NUMBER
ksulotot,                -- TOTAL NUMBER
to_date                  -- TIMESTAMP DATE
  (ksuloinft, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') 
from
x$ksulop 
where
ksulopna like '% Recovery' order by 1,
2 DESC,
5 ASC,
4 ASC
home |  up  |  mailbox