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

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,
Prashanth

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: Wed Dec 07 22:34:33 CST 2016

Total time taken to generate the page: 0.09853 seconds