V$DATAGUARD_STATS
SELECT NAME, VALUE, TIME_COMPUTED
FROM V$DATAGUARD_STATS
WHERE NAME IN ('apply lag', 'transport lag’);
FROM V$DATAGUARD_STATS
WHERE NAME IN ('apply lag', 'transport lag’);
V$MANAGED_STANDBY
SELECT PROCESS, THREAD#, SEQUENCE#, STATUS
FROM V$MANAGED_STANDBY;
FROM V$MANAGED_STANDBY;
V$ARCHIVE_DEST_STATUS
SELECT DEST_ID, STATUS, GAP_STATUS, ERROR
FROM V$ARCHIVE_DEST_STATUS
WHERE TYPE = 'PHYSICAL' AND GAP_STATUS != 'NO GAP';
FROM V$ARCHIVE_DEST_STATUS
WHERE TYPE = 'PHYSICAL' AND GAP_STATUS != 'NO GAP';
Watch Video Format: https://www.youtube.com/shorts/cOHRBI_KMUA
Very informative and well-explained tutorial. The Postgresql-tutorial concepts are easy to understand, and the examples are helpful for beginners. Great learning resource!Learn postgresql-tutorial.
ReplyDelete