This discussion is archived
2 Replies Latest reply: Apr 30, 2013 4:02 PM by Peter Gjelstrup RSS

Alter Session, same user

K- Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    >
    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 Guru
    Currently Being Moderated
    the other sessions of the same user (yes, the application here use all the same database user)
    Connection pool, maybe?

    Regards
    Peter

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points