2 Replies Latest reply: Apr 30, 2013 6:02 PM by Peter Gjelstrup RSS

    Alter Session, same user

    K-
      Good night community,

      I have issued a command Alter Session to set a different NLS_DATE_FORMAT for only one session of an user but, the other sessions of the same user (yes, the application here use all the same database user) got the changes.

      Is that predictable to happen? Is there a clausule to issue Alter Session only for a specific session of that user?

      Thank you very much!

      PS: If this is not the right place to ask this, could you move it? Thank you very much!
        • 1. Re: Alter Session, same user
          rp0428
          >
          I have issued a command Alter Session to set a different NLS_DATE_FORMAT for only one session of an user but, the other sessions of the same user (yes, the application here use all the same database user) got the changes.

          Is that predictable to happen? Is there a clausule to issue Alter Session only for a specific session of that user?
          >
          Show us the proof that you got that result. Post your 4 digit Oracle version and show us the sql*plus sessions you have created and the actual ALTER SESSION command you executed.

          ALTER SESSION has NO affect on other sessions whether those 'other' sessions are for the same user or not. A 'user' is NOT a session.
          • 2. Re: Alter Session, same user
            Peter Gjelstrup
            the other sessions of the same user (yes, the application here use all the same database user)
            Connection pool, maybe?

            Regards
            Peter