OraFAQ Forum: Server Administration » Changing Optimizer mode

Home » RDBMS Server » Server Administration » Changing Optimizer mode

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing Optimizer mode [message #205781]

Mon, 27 November 2006 09:36

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

Report message to a moderator