Re: Corrective Actions in Grid Control?
- From: Traci Eshleman <traci.l.eshleman@xxxxxxx>
- To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 5 Aug 2011 10:17:36 -0400
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@xxxxxxx* <brian.dommel@xxxxxxx>
On Fri, Aug 5, 2011 at 9:27 AM, Sheehan, Jeremy <
JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx> 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 ****
>
> ** **
>
Other related posts:
