I've got another session that I suspect isn't running with the 'proper' NLS settings for us in Oracle 11gR2. What can I query to show the NLS settings for a different active session – all of the NLS_* views reference my current session.
Oracle – How to View Active NLS Settings for Other Sessions
oracleoracle-11g-r2
Related Question
- Oracle Procedure – How to Write a Procedure to Kill Sessions Running Over 5 Minutes
- Oracle – Query Session Parameter Values of Running Session
- Oracle – How to Recreate Fixed Views
- Oracle – Query Execution Finishes First Time but Hangs on Second Run
- View current session roles for another session
- Oracle – Should Processes Limit Be Lower Than Sessions Parameter?
Best Answer
There is no simple way to achieve this. You can either do it by tracing the session or by using a login trigger. Here's an example of how to do it using a DB login trigger.
Logging table:
Public grant and synonym:
Database login trigger:
Test:
Obviously you'd be better off putting the table in an appropriate schema and granting on a per-user basis.
If you need help with another approach (session tracing), let me know.