APPLIED_SCN |
NUMBER |
|
Newest SCN at which all changes have been applied. The values in the APPLIED_SCN and NEWEST_SCN columns will match if all available redo log data has been processed. |
APPLIED_THREAD# |
NUMBER |
|
Thread number for the log file containing the APPLIED_SCN |
APPLIED_SEQUENCE# |
NUMBER |
|
Sequence number for the log file containing the APPLIED_SCN |
APPLIED_TIME |
DATE |
|
Estimate of the time and date of the APPLIED_SCN |
READ_SCN |
NUMBER |
|
All log data less than this SCN has been read and saved |
READ_THREAD# |
NUMBER |
|
Thread number for a log file containing the READ_SCN |
READ_SEQUENCE# |
NUMBER |
|
Sequence number for a log file containing the READ_SCN |
READ_TIME |
DATE |
|
Estimate of the time and date of the READ_SCN |
NEWEST_SCN |
NUMBER |
|
Most recent SCN available on the standby system. If no more logs are being shipped, then changes could be applied to this SCN. The values in the APPLIED_SCN and NEWEST_SCN columns will match if all available redo log data has been processed. |
NEWEST_THREAD# |
NUMBER |
|
Thread number for a log containing the NEWEST_SCN |
NEWEST_SEQUENCE# |
NUMBER |
|
Sequence number for a log containing the NEWEST_SCN |
NEWEST_TIME |
DATE |
|
Estimate of the time and date of the NEWEST_SCN |