Thursday, 18 September 2014

Apply/transport lags

Apply/transport lags:
Following queries the general synchronization status of standby database.

SQL> set linesize 120
SQL> set pagesize 500
SQL>
SQL> col name format a30
SQL> col value format a20
SQL> col TIME_COMPUTED format a15
SQL> col DATUM_TIME format a15
SQL>
SQL> select * from v$dataguard_stats;

No comments:

Post a Comment