Re: Corrective Actions in Grid Control?
Date: Fri, 5 Aug 2011 10:17:36 -0400
Message-ID: <CAG2UQDtgefvbPGksowW84zSDqD9h+xzb+mxB9-GHdOS7UPb3BA_at_mail.gmail.com>
Jeremy,
We have an 11g OMS and do use Corrective Actions in Grid Control when a metric threshold is reached for an Advanced Queuing and Streams Propagation job backlog is detected. The Corrective Action calls a stored procedure that stops and restarts the the queuing job or propagation process. We have the stored procedure email the DBA team that the action was performed and what the begin backlog count was and the end count after the restart to verify the transactions propagated successfully.
With our distributed environment we encounter that situation fairly regularly, so this eliminated a DBA manually having to do that. It has been working nicely.
*
Traci L. Eshleman
* | *Oracle Database Administrator* | *RR Donnelley*
1905 Horseshoe Road | Lancaster, PA 17602 | (: 717-391-5511 | *: *
traci.l.eshleman_at_rrd.com* <brian.dommel_at_rrd.com>
On Fri, Aug 5, 2011 at 9:27 AM, Sheehan, Jeremy < JEREMY.SHEEHAN_at_nexteraenergy.com> wrote:
> Is anyone using Corrective Actions in Grid Control? Just curious to see if
> anyone is using it and in what capacity they are using it. ****
>
> ** **
>
> If you are, do you have any trouble? Any concerns? ****
>
> ** **
>
> TIA!****
>
> ** **
>
> Jeremy ****
>
> ** **
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 05 2011 - 09:17:36 CDT