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

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


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 Received on Sat Mar 08 2008 - 03:36:31 CST

Original text of this message