Re: SQL faster "direct" than CM
- From: Stephen Andert <andert@xxxxxxxxx>
- To: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- Date: Mon, 25 Apr 2011 14:50:13 -0700
Yes, it is on a SAN. Not sure what other machines may be doing at the same
time, but even when the CM job and the TOAD job are run at the same time,
the TOAD job runs faster.
On Mon, Apr 25, 2011 at 2:52 PM, Stephane Faroult <sfaroult@xxxxxxxxxxxx>wrote:
> Running on a SAN and other machines connected to the same computing their
> stats at the same time?
>
> Stephane Faroult
> RoughSea Ltd <http://www.roughsea.com>
> Konagora <http://www.konagora.com>
> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
>
> On 04/25/2011 10:51 PM, 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?)
>
>
Other related posts: