How To Find Out Backlog Of Standby?

1.	How To Find Out Backlog Of Standby?
Answer» select ROUND((sysdate – a.NEXT_TIME)2460) as “Backlog”,m.SEQUENCE#-1 “Seq Applied”,m.process, m.STATUS from v$archived_log a, (select process,SEQUENCE#, status from v$managed_standby where process LIKE ‘%MRP%’)m where a.SEQUENCE#=(m.SEQUENCE#-1); select round((sysdate – a.NEXT_TIME)2460) as “Backlog”,m.SEQUENCE#-1 “Seq Applied”,m.process, m.status from v$archived_log a, (select process,SEQUENCE#, status from v$managed_standby where process like ‘%MRP%’)m where a.SEQUENCE#=(m.SEQUENCE#-1);

Answer»

select ROUND((sysdate – a.NEXT_TIME)*24*60) as “Backlog”,m.SEQUENCE#-1 “Seq Applied”,m.process, m.STATUS

from v$archived_log a, (select process,SEQUENCE#, status from v$managed_standby where process LIKE ‘%MRP%’)m where a.SEQUENCE#=(m.SEQUENCE#-1);

select round((sysdate – a.NEXT_TIME)*24*60) as “Backlog”,m.SEQUENCE#-1 “Seq Applied”,m.process, m.status

from v$archived_log a, (select process,SEQUENCE#, status from v$managed_standby where process like ‘%MRP%’)m where a.SEQUENCE#=(m.SEQUENCE#-1);

Discussion