Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter session

Re: alter session

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 10 May 2002 18:18:49 GMT
Message-ID: <3CDC0EFD.953A3EA0@exesolutions.com>


clueless wrote:

> Hi gang,
>
> Oracle 8.1.6 running on W2K
> I am trying to alter the session to change the optimizer_mode parameter from
> CHOOSE to RULE.
> I want to do this to only one specific user. I know I can do it to myself
> with the "Alter session set optimizer_mode=RULE" command.
>
> How do I do it for another user who is already logged in.
>
> Cheers,
> Clueless

You walk over to their desk and show them how to type it in.

Daniel Morgan Received on Fri May 10 2002 - 13:18:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US