RE: Poor man's standby monitoring
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Dec 2010 09:53:50 -0800 (PST)
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
