RE: Poor man's standby monitoring

From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 23 Dec 2010 09:53:50 -0800 (PST)
Message-ID: <485587.20995.qm_at_web80601.mail.mud.yahoo.com>



> This works for an exclusive primary, but doesn't quite work for
> a RAC primary (since there are multiple redo threads):
> ...

The SQL below works for RAC when LGWR is shipping redo:

SQL> select x.sequence# - y.sequence# gap   2 from (select thread#, sequence# from v$managed_standby where process = 'MRP0') x,   3 (select thread#, sequence# from v$managed_standby where process = 'RFS' and client_process = 'LGWR') y   4 where x.thread# = y.thread#;

       GAP


         0

It queries the view twice. There may be a way to query it only once.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 23 2010 - 11:53:50 CST

Original text of this message