Re: OPTIIMIZER_MODE = NONE in V$SQLAREA

From: dias <ydias_at_hotmail.com>
Date: 15 Jul 2002 14:29:27 -0700
Message-ID: <55a68b47.0207151329.3f4e84dd@posting.google.com>

Sorry,

What does the value "NONE" mean in the column OPTIMIZER_MODE of the view V$SQLAREA ?

Thanks

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<agufqh$28u$1_at_lust.ihug.co.nz>...
> And your question is....???
>
> HJR
>
>
> "dias" <ydias_at_hotmail.com> wrote in message
> news:55a68b47.0207150437.601446b9_at_posting.google.com...
> > Hi,
> >
> > In a 8.0.5 db on Solaris, I have a lot of sql statements with
> > optimizer_mode=none in the view V$SQLAREA.
> >
> > The optimizer_mode is set to RULE in the init.ora and statistics are
> > computed on all the tables not SYS and SYSTEM (of course, optimizer
> > mode = rule don't need statistics).
> >
> > These statements are not only recursive ones, and also application
> > statement.
> >
> > Thanks
Received on Mon Jul 15 2002 - 16:29:27 CDT