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')