Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HOw to know which optimiser server using
Try:
SQL> connect system/password
SQL> select * from v$parameter where name like '%opt%';
NUM NAME TYPE VALUE ISDEFAULT ---------- -------------------- ---------- --------------- --------- 174 optimizer mode 2 CHOOSE FALSE
If you don't have the system password, check with your system administrator - he should be able to answer your question.
Remember that this is determined by the init.ora parameter OPTIMIZER MODE (American spelling - not British), so it can change from one database to the other.
Hope this helps
-- Karl Oracle Certified DBA Sateesh Burgadda wrote in message <34BFA846.2092_at_evolving.com>...Received on Fri Jan 16 1998 - 00:00:00 CST
>hi!
>
>I would like to know which optimiser( cost based or rule based)
>is used on my server.
>
>I tried to see init.ora file but nothing found.
>
>Can u help me to know how.
>
>
>PL reply
>Sateesh
--