This content has been marked as final. Show 2 replies
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.