HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3

From: Pedro de Souza Rodrigues Filho <green_stone.ford_at_e-mail.com>
Date: 1997/10/24
Message-ID: <34509B41.BE476D86@e-mail.com>#1/1

--------------F643303536DCD590FFF6C898
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

        Hi fellows, this is my first time in this discution group and I
havy some interest question for you.
        As a DBA, I was trying optimize a user query without change the

database, just improoving the query. At certain moment I've decided use hints because the explain plan showed an incorrect use of index. The hints doesn't take effect !! After hours working in the problem, I discovered in an old manual that hints are valid just in optimizer_mode = cost, but when I try startup the database with this option in the init.ora, I receive a message saying this option "cost" is invalid. The default value for this parameter is "cost", but in the SQL*DBA, the option shows "choose" mode.

By the way, I've contact Oracle Local support, but until

now..................
        If one of you could help me I will be so pleased and thankfull.
        Thanks in advance.

--------------F643303536DCD590FFF6C898

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<HTML>
        Hi fellows, this is my first
time in this discution group and I havy some interest question for you.
         As a DBA, I was trying
optimize a user query without change the database, just improoving the query. At certain moment I've decided use hints because the explain plan showed an incorrect use of  index. The hints doesn't take effect !! After hours working in the problem, I discovered in an old manual that hints are valid just in optimizer_mode = cost, but when I try startup the database with this option in the init.ora, I receive a message saying this option "cost" is invalid. The default value for this parameter is "cost", but in the SQL*DBA, the option shows "choose" mode.
         By the way, I've contact

Oracle Local support, but until now..................</B>

         If one of you could help
me I will be so pleased and thankfull.
         Thanks in advance.</HTML>

--------------F643303536DCD590FFF6C898-- Received on Fri Oct 24 1997 - 00:00:00 CDT