> Don't get me wrong - I've been really impressed with the hotsos > profiler, orasrp and the like, but it ain't normally that hard to find > the worst piece of code in a system :-) ...unless, of course, the case when "bad" statement doesn't use bind variables and executed many times (in such case tkprof is useless and orasrp might be helpful). --=20 Egor http://www.oracledba.ru/orasrp/ Free Oracle Session Resource Profiler -- //www.freelists.org/webpage/oracle-l