Re: SQL faster "direct" than CM
Date: Mon, 25 Apr 2011 16:16:14 -0700
Message-ID: <BANLkTin4Y4TFeLP+2e95TYf8=q3XvQka7w_at_mail.gmail.com>
Thanks for the suggestions everyone.
No RAC.
CM is same machine as DB.
I am working with DEV folks to get some tracing done to compare explain plans
On Mon, Apr 25, 2011 at 3:14 PM, Harel Safra <harel.safra_at_gmail.com> wrote:
> 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-lReceived on Mon Apr 25 2011 - 18:16:14 CDT