V$RECOVERY_PROGRESS For Oracle Recovery

V$RECOVERY_PROGRESS For Oracle Recovery   V$RECOVERY_PROGRESS view Major overhaul for Media Recovery and Physical Standby in 10gR2 Tracks redo apply rate: overall and recent Breakdown of apply vs. checkpoint time per log   Recovery performance can be monitored using V$RECOVERY_PROGRESS and several system events and stats. However, more work is needed in this space to help discover which parts of the recovery algorithm are taking a long time. The discussion here mainly applies to RDBMS Release 11.2, but can also be applicable for future releases. Below, new stats are described in bold-faced.   more info: http://emrebaransel.blogspot.jp/2010/06/mrp-speed-log-apply-rate-of-standby.html