Re: SQL faster "direct" than CM

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Tue, 26 Apr 2011 10:56:33 +0800
Message-ID: <BANLkTimy4pHxKKfqauQHLVFeWevrkjtSTQ_at_mail.gmail.com>

Is it a Query that is returning a large number of rows? Or is it some DML?

Hemant K Chitale

sent from my smartphone
On 26 Apr 2011 04:53, "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 Mon Apr 25 2011 - 21:56:33 CDT