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

  • From: Sandra Becker <sbecker6925@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 30 May 2014 16:21:46 -0600

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: