This content has been marked as final. Show 4 replies
I don't know if there is a way to peek into another session but you can capture the NLS information via SYS_CONTEXT from LOGON triggers.1 person found this helpful
Check below link :1 person found this helpful
May be of your interest.
SYS_CONTEXT with a LOGON trigger seems to be the only way to get these informations.
Dion Cho uses oradebug but, as I said, the "dump" doesn't extracts the NLS parameters, only those related to optimizer are extract.