Hi guys,
Simple question: Why there is always difference between the value of "Average Apply Rate" in V$RECOVERY_PROGRESS and in dgmgrl?
Thanks in advance.
SELECT START_TIME , ITEM, SOFAR || ' ' || UNITS Sofar FROM V$RECOVERY_PROGRESS WHERE ITEM IN ( 'Average Apply Rate');
START_TIM ITEM SOFAR
--------- -------------------------------- ----------------------------------------
15-JUL-16 Average Apply Rate 1076 KB/sec
DGMGRL> SHOW DATABASE oradb_s2
Database - oradb_s2
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 386.00 KByte/s
Real Time Query: OFF
Instance(s):
ORADB_S2
Database Status:
SUCCESS