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: 17 Jul 2002 12:58:01 -0700
Message-ID: <55a68b47.0207171158.c792234@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.



These statements are not only recursive ones, and also application
statements.



With this value "NONE", how can I know which optimizer the queries are
using in the database ?



Thanks
Received on Wed Jul 17 2002 - 14:58:01 CDT












Original text of this message













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