|
A little more info to help with this research. The undocumented view v$rfs_thread (based on x$krfsthrd) has a column last_redo_blk#. Even if there's no log sequence (last_redo_seq#) change, this column should gradually change if you have SRLs. It tells you where you are inside the same redo logfile. I bet if you don't use SRLs, this column should stay constant. Let us know if that's the case. |
|