Re: SQL faster "direct" than CM

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 25 Apr 2011 23:52:05 +0200
Message-ID: <4DB5ED05.1090005_at_roughsea.com>

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?)
>
> Stephen
>

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

Received on Mon Apr 25 2011 - 16:52:05 CDT