V$LOGSTDBY_STATS displays statistics, current state, and status information related to SQL Apply. No rows are returned from this view when SQL Apply is not running. This view is only meaningful in the context of a logical standby database.
All statistics shown in this view are reinitialized at each SQL Apply start.
||Name of the statistic, state, or status:
Note: Many of the following statistics are subject to change or deletion; programmers should write application code to tolerate missing or extra statistics.
||Value of the statistic or state information|
Footnote 1 In case SQL Apply is not running in real time mode, this may not reflect time spent in gap resolution, but simply the time spent waiting for the most recent archived log to show up at the logical standby.
Footnote 2 In case SQL Apply is not running in real time mode, this will include time that SQL Apply spent everytime it finished processing all archived logs registered with it, and waited for the next log to be archived.