Update stby-arch-gap-check.sql

coderdba · web-flow · commit aece4368e88a · 2016-09-09T12:24:29.000+05:30
diff --git a/dataguard11g-scripts/stby-arch-gap-check.sql b/dataguard11g-scripts/stby-arch-gap-check.sql
@@ -1,3 +1,10 @@
+set echo on
+
 select THREAD#,SEQUENCE#,PROCESS,STATUS
 from v$managed_standby
 order by 1,2;
+
+select * from v$archive_gap;
+
+echo off
+
