SQL faster "direct" than CM

  • From: Stephen Andert <andert@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 25 Apr 2011 13:51:57 -0700

Do you have any ideas on why this would run in Toad in 2 minutes and take
over 4 hours running through the concurrent manager?    Actually up until
this past week, 4 minutes is the usual run time for this job.


I have looked at StatsPack for one of the 4 hour runs and other than about
75% of the time being I/O related. did not see anything out of line.


Financials 11.5.8

DB 9.2.0.4.0

(what am I missing?)
Stephen

Other related posts: