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

From: <vitalisman_at_gmail.com>
Date: Sat, 8 Mar 2008 01:16:21 -0800 (PST)
Message-ID: <4493f7bb-16b8-459e-a393-eac8a9f38557@p73g2000hsd.googlegroups.com>


On 8 mar, 07:16, Jack <jr..._at_stirlingonline.com> wrote:
> 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)?
>
> Lots of info on setting, haven't been able to find anything about
> checking these once they've been set.
>
> Thank you, Jack

Which Oracle version?
When and from where do you want to check those parameter values? Received on Sat Mar 08 2008 - 03:16:21 CST

Original text of this message