Sequences out of sync
Hello everyone, is there a scriptable way of figuring out if the database sequences are out of sync?
We have almost 200 sequences and over 900 databases. Every once in a blue moon we have an application problem that takes us a few hours of trouble shooting to figure out that a sequence is out of sync. I fix the offending sequence but it always makes me wonder about the other 199 and we don't have time to check every one of them.
I have googled this a lot of times and have always came up empty handed which makes me think the answer is no but I wanted to ask just to be 100% sure.
Thank you for your help in advanced!
Click Here to Expand Forum to Full Width