Re: SQL faster "direct" than CM
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Tue, 26 Apr 2011 10:27:56 +0200
Hi Stephen,
some jdbc drivers (< 10.2.0.4) don't support bind peeking,
check if CM uses one of those:
Oracle JDBC Thin Driver Generates Different Execution Plan (Doc ID 273635.1)
Regards
Dimitre
On 25/04/2011 22:51, Stephen Andert wrote:
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:
