MTS and Cost Based Analyzer

Why would you be looking to change/implement something if you're not aware of the advantages/disadvantages?

Changing to the cost based optimizer requires that both the DBA(s) and the Developer(s) understand how and why it works. Although a simple change to your init<SID>.ora file (yet another reference to that pesky animal) will enable cost based optimization, you'll probably need to set up some maintenance tasks (table/schema/database analysis comes to mind) and review slow running SQL to see how the change has affected some of your queries. There are additional initialization parameters you may or may not want to set in connection with the change.

MTS is enable through another initialization parameter (I'd go to OTN and print out the doc on Initialization Parameters and become VERY familiar with it). There are however numerous other considerations, including client configuration and setup of your listener. Again, go to OTN and check out the docs.

Regards,

David A. Barbour
Oracle DBA

> Venkat_Kalepalli wrote:
>
> Hello folks!
>
> I am working in SUN solaris 5.6 with Oracle 8i. I want to implement
> MTS on the Oracle server. Next we are running with Rule based
> optimizer and we want to change to costbased optimizer.
>
> I want to know what are the advantages we get on this and what are the
> steps to implement this?
>
> Any help is grateful...
>
> Rgd
> Venkat
> DBA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: dbarbour_at_nucentrix.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).