Oracle Grid Control???? On Sep 20, 2011, at 1:51 PM, Uzzell, Stephan wrote: > Hey Listers, > Any cool tricks for monitoring a bunch of physical standby environments? We > have 20 or so physical standby databases, and are having trouble figuring the > best strategy to monitor them. We do not currently have enough DBAs to sit > around watching them. > > We are currently using two scheduled tasks to grab the current_scn from > v$database, alternating every 45 minutes or so; we then parse the two output > files using perl, do some quick math, and as long as there is a change in the > SCN, we feel things are probably OK. > > The problem is that the SCN does not advance at a regular interval. Some > database are busier than others. Some database therefore do not have the SCN > advance between a pair of tests; other times one of the scheduled tasks > hangs. So we get periodic "BAD" reports that are not really bad. > > Definitely not the best system. Any recommendations for the best way to > monitor - to only get alerts if / when there is actually something wrong? > > Thanks! > > Stephan Uzzell > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l