Re: SQL faster "direct" than CM

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 26 Apr 2011 08:44:45 -0400
Message-Id: <C84D29A7-F1F0-49B7-89A6-C5C49C560626_at_gmail.com>



What are you running? If it is select, toad would normally fetch x rows and will wait. Sqlplus won't, so it would seem longer. Apologies if this is not the case, but encountered same issue here with a developer at work last week.

Raj

Sent from my iPhone

On Apr 25, 2011, at 4:51 PM, Stephen Andert <andert_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 26 2011 - 07:44:45 CDT

Original text of this message