Home » RDBMS Server » Server Administration » Changing Optimizer mode
Changing Optimizer mode [message #205781] Mon, 27 November 2006 09:36 Go to next message
Messages: 67
Registered: November 2005
Location: chennai

I want to change my optimizer mode=ALL_ROWS to CHOOSE in my database.

alter session set optimizer_mode='CHOOSE';

Is this will work to change the mode? (not only in session level)in database level too.

DB: Oracle 10gR2
OS: Sun Solaris 5.8

Please advice.

Thanks and Regards,

Re: Changing Optimizer mode [message #205783 is a reply to message #205781] Mon, 27 November 2006 09:44 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
set it in the init.ora
Previous Topic: ORACLE Management Server problem
Next Topic: db_block_buffer
Goto Forum:

Current Time: Fri Aug 18 01:48:33 CDT 2017

Total time taken to generate the page: 0.12106 seconds