Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |