Re: Queries running slow during a batch process

Hello Sebastien

It's OPTIMIZER_MODE=CHOOSE and the statistics are properly gathered and up-to-date. The Oracle is the 9.2.0.6.0 and the OS is Solaris 8.

Thanks!

Eduardo

SL wrote:
> Ferrari_NYC a écrit :
>
> > Hello
> >
> > We do have a batch process which runs a bunch of inserts, updates and
> > select statments.
> >
> > Some of the SELECT statments are taking around 1-2 secs on empty
> > tables. We took the SQL from the batch and runned it into SQL*Plus and
> > PL/SQL Developer and we found that were doing some full scan in some
> > tables. We created an index which dropped the time to 0.03 secs, which
> > is perfect. In the batch, the statments are still taking 1-2 secs to
> > run, so we start looking into the V$SQL table and we found that the
> > statments that are taking that amount of time has the OPTIMIZER_MODE
> > column in V$SQL set to NONE.
> >
> > What does that really means?
>
> Hello,
>
> What is the value of the init parameter optimizer_mode ?
> Are the CBO statistics properly gathered and up-to-date ?
>
> Besides, what are Oracle version and platform OS type&version ?
>
> --
> SL
Received on Wed Sep 20 2006 - 09:48:14 CDT