SQL faster "direct" than CM
From: Stephen Andert <andert_at_gmail.com>
Date: Mon, 25 Apr 2011 13:51:57 -0700
Message-ID: <BANLkTikWi+OPxsnVo=3mLkF-pmP9WUgCJg_at_mail.gmail.com>
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.
Date: Mon, 25 Apr 2011 13:51:57 -0700
Message-ID: <BANLkTikWi+OPxsnVo=3mLkF-pmP9WUgCJg_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 25 2011 - 15:51:57 CDT