gv$archive_dest_status and standby db
According to ref guide for V$ARCHIVE_DEST_STATUS
APPLIED_SEQ# ...
Identifies the log sequence number of the most recent applied redo log received at the destination
So why do I get more than one row like the following
SQL> select applied_seq#, applied_thread#
2 from gv$archive_dest_status
3 where applied_thread# > 0;
APPLIED_SEQ# APPLIED_THREAD#
------------ ---------------
6625 1
6620 1
SQL>
From the ref guide I would expect to get *the most recent*
I'm stmontgo and I approve of this message