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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
