V$RECOVERY_PROGRESS definition in Oracle Database 11.2
V$RECOVERY_PROGRESS

select
  START_TIME,                              -- START_TIME DATE
  TYPE,                                    -- TYPE VARCHAR2(64)
  ITEM,                                    -- ITEM VARCHAR2(32)
  UNITS,                                   -- UNITS VARCHAR2(32)
  SOFAR,                                   -- SOFAR NUMBER
  TOTAL,                                   -- TOTAL NUMBER
  TIMESTAMP,                               -- TIMESTAMP DATE
  COMMENTS                                 -- COMMENTS VARCHAR2(208)
from
  GV$RECOVERY_PROGRESS
where
  inst_id = USERENV('Instance')

home |  up