V$REDO_DEST_RESP_HISTOGRAM provides statistical information for each redo transport destination.

Column Datatype Description
DEST_ID NUMBER A non-negative integer value from 1 - 10 for each possible LGWR SYNC standby destination
TIME VARCHAR2(20) A text string that shows the last wall-clock time that a bucket was hit
DURATION NUMBER A positive integer value that represents a bucket of seconds, 1, 2, 3, up to 300 seconds, followed by 5 additional buckets that represent 600, 1200, 2400, 4800, and 9600 ( >= 4801) seconds
FREQUENCY NUMBER A non-negative integer that shows the number of times a particular bucket was hit by the SYNC LNS process