Forum Discussion
Algebraic_Mirror
Oct 25, 2011Cirrostratus
It doesn't look to be the clean_db.pl script, but I think this is very much on the right track! That directory "/usr/share/ts/bin" that contains the clean_db.pl script ALSO contains a huge number of other scripts that operate on the database. I'm pretty sure it's one of them. I guess I'm not going to dig too much deeper, since this is starting to look like normal operation. If it starts hurting performance I'll file a ticket, but since it spikes the CPU for one minute and then backs off for two minutes, things stay caught up and nothing gets too hurt.
Also, I need to modify my original post: my newly rebuilt ASM is starting to show this problem again, but to a lesser degree. My guess is that because it has been up for a much shorter period, it has a smaller database and queries execute faster. As the DB grows, the queries must slow down and cause CPU spikes, giving me this sawtooth pattern.