<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4807.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=656343211-31032003>There
is no view, table available to get the data u want.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=656343211-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=656343211-31032003>But
you can write an after logon trigger which inserts into a table i. e.
all_session_nls </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=656343211-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=656343211-31032003>select
substr(parameter, 1, 30),<BR> substr(value,
1, 40)<BR>from v$nls_parameters<BR>where parameter != 'NLS_CHARACTERSET'
and<BR> parameter != 'NLS_NCHAR_CHARACTERSET'; with the
username</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=656343211-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=656343211-31032003>Regards,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=656343211-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=656343211-31032003>Ercan</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face="Times New Roman" size=2>-----Ursprüngliche
Nachricht-----<BR><B>Von:</B> Antonio Pereyra Miranda
[mailto:[Email Address Removed] am:</B> Montag, 31. März 2003
12:53<BR><B>An:</B> LazyDBA.com Discussion<BR><B>Betreff:</B> How can i know
the nls session parameter that are being used in another
session?<BR></DIV></FONT>
<DIV><FONT face=Arial size=2>How can i know the nls session parameter that are
being used in another session?</FONT></DIV>
<DIV><FONT face=Arial size=2>Not in my session (In My own session it is as
trivial as select * from NLS_SESSION_PARAMETER;)</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks in
advance</FONT></DIV></BLOCKQUOTE></BODY></HTML>
Oracle LazyDBA home page