Re: Checking value set via "set transaction" or "alter session"

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Sat, 08 Mar 2008 10:38:23 +0100
Message-ID: <63f54gF277oi9U2@mid.individual.net>


Thomas Kellerer wrote on 08.03.2008 10:36:
> Jack wrote on 08.03.2008 07:16:

>> This seemed like it would be a simple question to answer, but I can't
>> find anything on either.
>>
>> Can anyone shed some light on how to determine the value I have used
>> for "set transaction" (say to "read only") and for "alter
>> session" (say to change the NLS_DATE_FORMAT)?
>>

>
> For the NLS parameter see:
> <http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4220.htm#sthref2021>
>
>
>
> For the transaction state I don't know.
> Check out the Reference manual for this:
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm

And the sys_context function might also be interesting for you:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#i1038176 Received on Sat Mar 08 2008 - 03:38:23 CST

Original text of this message