The best thing is to ask the dba for a tkprof... And how often tables being analyzed/gather stats?
http://www.perf-engg.com A performance engineering forum
Forum Rules