| Users and default optimizer_mode [message #134014] |
Tue, 23 August 2005 05:18  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
