Re: OPTIIMIZER_MODE = NONE in V$SQLAREA

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 15 Jul 2002 22:40:24 +1000
Message-ID: <agufqh$28u$1@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 - 07:40:24 CDT