H
hjboxem
Guest
You could use something like this: tail -fn0 sports.lg | \ while read line ; do echo "$line" | egrep -e "pattern1|pattern2|etc" if [ $? = 0 ] then ... format and send the message ... fi done I have written my own monitoring script which runs every minute and checks most vital signs of the database. This includes the size of the BI extent(s), BI filesystem space, active transactions (> 10 minutes), transaction backouts that occurred due to long active transactions being aborted and much more. It really helps in getting in control on the way the database is behaving and helps us solving problems before the users are affected by it. ProTop is probably *much* better, but if you have some experience with shell scripting and read ProMon statistics you should be able to get your own monitoring. I have gathered much helpful information from the PUG sessions in the past and used this to enhance our monitoring. Thanks to all the speakers! ;-)
Continue reading...
Continue reading...