The Oracle tuning pack is a great tool for finding problem sql before anyone knows it is a problem. I don't always foolow its advice exactly but it points me in the right direction. I think that time wise it is a lot more effective than tkprof and statspack. There are other programs that will probably give you the same thing.