Re: Need up-to-the-minute info on log apply lag
Date: Sat, 31 May 2014 05:56:14 +0530
Message-ID: <CAABGLuLumX=Xbm=tmdrFd2-VgLVppKXy1S5Ats1OeqB+DkE8Gg_at_mail.gmail.com>
Hi Sandra,
When the standby is in open/read-only mode, there is one more view where you can verify information such as last time updated, i.e. *V$STANDBY_EVENT_HISTOGRAM* - view shows the history of apply lag values since the standby instance was last started. You can also query from *v$dataguard_stats* for the status.
Here is sample query:
SQL> SELECT * FROM V$STANDBY_EVENT_HISTOGRAM WHERE NAME = '*apply lag*' AND
COUNT > 0;
I hope this is what you looking for.
Thank you
On Sat, May 31, 2014 at 3:51 AM, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> Oracle EE 11.2.0.2
>
> We are planning to change a production application to read from a physical
> standby database to offload read activity from the primary. One of the
> requirements is up-to-the-minute information on log apply lag.
> Unfortunately, v$archived_log does not provide this information. Is there
> another table or view we can query for this information?
> Appreciate any help you can give me.
> --
> Sandy
> GHX
>
-- Nassyam Basha. Oracle DBA *The Pythian Group * <http://www.pythian.com/> 11g OCP Certified, Blogger Co-Author: Oracle Data Guard 11gR2 <http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900> Member of Oraworld-team <http://www.oraworld-team.com> Visit My Blog <http://www.oracle-ckpt.com> Let's Connect - Linkedin Profile <http://in.linkedin.com/in/nassyambasha/> My Twitter <https://twitter.com/nassyambasha> My Facebook <https://www.facebook.com/nassyambasha> -- http://www.freelists.org/webpage/oracle-lReceived on Sat May 31 2014 - 02:26:14 CEST