Home » RDBMS Server » Performance Tuning » Users and default optimizer_mode
Users and default optimizer_mode [message #134014] Tue, 23 August 2005 05:18 Go to next message
Scott Cowan
Messages: 15
Registered: February 2004
Junior Member
On a system that I've taken over, the developers have one user account that has optimizer_mode as rule when they log on and they have another that has choose, I thought that the optimizer mode could only be set within the init.ora , hint or alter system command.

Is there a role/priv that can set this as default for a user when they logon ?

Regards

Scott
Re: Users and default optimizer_mode [message #134030 is a reply to message #134014] Tue, 23 August 2005 06:34 Go to previous messageGo to next message
mchadder
Messages: 224
Registered: May 2005
Location: UK
Senior Member
Hello.

I would guess there's an AFTER LOGON trigger setting it using ALTER SESSION, i.e.
SQL> ALTER SESSION SET OPTIMIZER_MODE = FIRST_ROWS;

Session altered.

You need to identify the trigger, and work out why it's doing what it's doing...

Rgds
icon7.gif  Re: Users and default optimizer_mode [message #134058 is a reply to message #134030] Tue, 23 August 2005 07:57 Go to previous message
Scott Cowan
Messages: 15
Registered: February 2004
Junior Member
Genius , you nailed it !!!

thanks

Scott
Previous Topic: log file sync waits
Next Topic: Partitioning of tables need sugession
Goto Forum:
  


Current Time: Tue Dec 06 21:03:08 CST 2022