$ sqlplus / as sysdba SQL> COL VALUE FOR A17 COL SOURCE_DB_UNIQUE_NAME FOR A22 COL NAME FOR A23 COL UNIT FOR A29 COL TIME_COMPUTED FOR A21 COL DATUM_TIME FOR A21 COL CON_ID FOR 9 SET LINES 300 SQL> SELECT * FROM v$dataguard_stats; SOURCE_DBID SOURCE_DB_UNIQUE_NAME NAME VALUE UNIT TIME_COMPUTED DATUM_TIME CON_ID ----------- ---------------------- ----------------------- ----------------- ----------------------------- --------------------- --------------------- ------ 0 transport lag +00 00:00:00 day(2) to second(0) interval 08/20/2024 17:58:14 08/20/2024 17:58:13 0 0 apply lag +00 00:00:00 day(2) to second(0) interval 08/20/2024 17:58:14 08/20/2024 17:58:13 0 0 apply finish time +00 00:00:00.000 day(2) to second(3) interval 08/20/2024 17:58:14 0 0 estimated startup time 26 second 08/20/2024 17:58:14 0 SQL>