Re: Need up-to-the-minute info on log apply lag

You can look at selecting from V$DATAGUARD_STATS for detailed time info on apply and transport lag, and you can also select from V$ARCHIVE_DEST_STATUS if you just want to see if there's a gap or not.

Regards,
Oscar

On Sat, May 31, 2014 at 8:21 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
>

--
http://www.freelists.org/webpage/oracle-l