Re: Need up-to-the-minute info on log apply lag
- From: Oscar Ofiana <oj.ofiana@xxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Sat, 31 May 2014 08:33:56 +1000
Hi Sandra,
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@xxxxxxxxx>
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
>
Other related posts:
