Checking lag
From: yudhi s <learnerdatabase99_at_gmail.com>
Date: Tue, 16 Jul 2024 18:57:48 +0530
Message-ID: <CAEzWdqfFuNonH4frJyLSQVFm63PPf-WMM_Zm0_ro01=Uru1RAw_at_mail.gmail.com>
Hi All,
Date: Tue, 16 Jul 2024 18:57:48 +0530
Message-ID: <CAEzWdqfFuNonH4frJyLSQVFm63PPf-WMM_Zm0_ro01=Uru1RAw_at_mail.gmail.com>
Hi All,
It's oracle version 19.21. Is there possible way to get the lag between the primary and DR database in duration with units as seconds/minutes/hours?
All i find is the data dictionary views like v$database,v$standby_log,v$archived_log,v$dataguard_stats tec. But not able to make these query such a way that it will give the results in unit as "seconds" of lag.
The requirement is to use this query in one of the application which will be running it in certain interval before querying data, to ensure the lag is minimal otherwise take some action accordingly on the data fetch queries from teh DR database.
Regards
Yudhi
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 16 2024 - 15:27:48 CEST