Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OPTIIMIZER_MODE = NONE in V$SQLAREA

OPTIIMIZER_MODE = NONE in V$SQLAREA

From: dias <ydias_at_hotmail.com>
Date: 15 Jul 2002 05:37:47 -0700
Message-ID: <55a68b47.0207150437.601446b9@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:37:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US