Re: SQL faster "direct" than CM

From: Harel Safra <harel.safra_at_gmail.com>
Date: Tue, 26 Apr 2011 01:14:08 +0300
Message-ID: <BANLkTimHXJPS0Np+5c-vA5m9awi2t-kxtQ_at_mail.gmail.com>

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_at_gmail.com> 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_at_roughsea.com
>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?)
>>
>>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 25 2011 - 17:14:08 CDT