Monitor
Monitoring Oracle Change Data Capture Queues
dmann — Thu, 07/29/2010 - 12:24
I shared a shell script that will check Oracle CDC Queues to make sure they aren't going stale. If your CDC consumer has not picked up changes in 48-72 hours then something may be wrong. The scripts can be customized to alert at any interval, hopefully this will serve as a good 'nudge' to get you going in the right direction.
Everything you need is here.
If you are an OEM user you can probably grab the SQL I shared and modify it for use with OEM User Defined Metrics or alerting.
-Dave
