Home » RDBMS Server » Server Administration » DBA Question
DBA Question [message #55569] Fri, 31 January 2003 15:10 Go to next message
Rizwan Qazi
Messages: 135
Registered: August 2002
Senior Member
How do I alter the optimizer mode that my database is running in from RULE to COST based?

Riz

Report message to a moderator

Re: DBA Question [message #55571 is a reply to message #55569] Fri, 31 January 2003 15:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
add the following to initsid.ora and toggle the database uing this initfile.
timed_statistics = true
optimizer_mode=choose

Report message to a moderator

Previous Topic: DB optimization/performance
Next Topic: archive log list doesn't work as sysdba
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:51:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.