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: 10672
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: Sun Oct 23 18:53:49 CDT 2016

Total time taken to generate the page: 0.09262 seconds