Re: SQL faster "direct" than CM
- From: Harel Safra <harel.safra@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Tue, 26 Apr 2011 01:14:08 +0300
Is there a difference in the execution plans? Can you trace the sessions?
Harel Safra
Sent from my phone.
On Apr 26, 2011 12:51 AM, "Stephen Andert" <andert@xxxxxxxxx> wrote:
> 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:
